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
2676
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
December 3, 2020
448
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
2676
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
December 3, 2020
448
Hi Jones,

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

Best regards,
Trowa
Posts
2676
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
December 3, 2020
448
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.

Subscribe To Our Newsletter!

The Best of CCM in Your Inbox

Subscribe To Our Newsletter!