I am trying to create a macro that will look at a list of dates in column B then copy and paste the data in column C and D to another sheet in one place, then look to the next date in column B and copy and paste the data into the other sheet in another place. Can anyone please help?
Since we need to compare the dates from sheet1 and sheet2 they need to be in the same format (at least it's easier to handle). Therefore I used row 4 of sheet2 to input the date. Then I changed the text color to white so you don't see it.