Copy and Paste certain columns based on dates
Solved/Closed
Related:
- Copy and Paste certain columns based on dates
- Compare two worksheets and paste differences to another sheet - excel vba free download ✓ - Excel Forum
- Display two columns in data validation list but return only one - Guide
- Excel match two columns and output third ✓ - Excel Forum
- We couldn't find an account matching the login info you entered, but found an account that closely matches based on your login history ✓ - Facebook Forum
- Insert a new sheet at the end of the tab names and paste the range names starting in cell a1. autofit columns a:b and name the worksheet as range names. ✓ - Excel Forum
3 responses
TrowaD
Posts
2921
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
December 27, 2022
552
Sep 8, 2011 at 09:04 AM
Sep 8, 2011 at 09:04 AM
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
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
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
TrowaD
Posts
2921
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
December 27, 2022
552
Sep 12, 2011 at 09:39 AM
Sep 12, 2011 at 09:39 AM
Hi Jones,
It's clear to me what you want and am working on the code.
Best regards,
Trowa
It's clear to me what you want and am working on the code.
Best regards,
Trowa
TrowaD
Posts
2921
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
December 27, 2022
552
Sep 13, 2011 at 08:55 AM
Sep 13, 2011 at 08:55 AM
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
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
