Hi, My Excel question/problem goes like this...
On sheet 1 I enter a time in column A Row 2. If the time is AM I want it to go to sheet 2 column B row 3, but if it is PM, I want sheet 3 column B row 3. Also if column B row 3 on sheet 2 has a time in it, then it should also move over to column C row 2 and column D row 2 from sheet 1. How do I do this?:upset:
On sheet 1 I enter a time in column A Row 2. If the time is AM I want it to go to sheet 2 column B row 3, but if it is PM, I want sheet 3 column B row 3. Also if column B row 3 on sheet 2 has a time in it, then it should also move over to column C row 2 and column D row 2 from sheet 1. How do I do this?:upset:
