Copy and Paste certain columns based on dates

Solved/Closed
Report
-
 jones835 -
Hello,

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?

Thanks

3 replies

Posts
2829
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
November 22, 2021
490
Hi Jones,

Your question is pretty vague.

quote: "look at a list of dates in column B".
What dates are we looking for?

quote: "paste the data in column C and D to another sheet in one place".
Which place?

quote: "into the other sheet in another place".
You mean same destination sheet?
By another place you mean the next row?

Maybe it's best if you upload your file using a filesharing site like speedyshare.com and post back the link.
Explain in detail what you want to achieve.

Best regards,
Trowa
Hi Trowa

Sorry for being so vague.

Here is a link to the file

http://www.speedyshare.com/files/30230162/test.xls

Basically what I want to do, is copy the information in columns C and D in sheet 1 and paste them into sheet 2 under the correct date.

Let me know if that doesn't make sense.

Thanks
Posts
2829
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
November 22, 2021
490
Hi Jones,

It's clear to me what you want and am working on the code.

Best regards,
Trowa
Posts
2829
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
November 22, 2021
490
Hi Jones,

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.

Here is your file:
https://authentification.site/files/30298761/Jones_test.xls

I hope you like the result.

Best regards,
Trowa
That's great! Thanks so much for your help.