Copy and Paste certain columns based on dates
Solved/Closed
Related:
- Copy and Paste certain columns based on dates
- Tweetdeck larger columns - Guide
- Display two columns in data validation list but return only one - Guide
- Instagram account based in wrong country - Instagram Forum
- Different dates of "end to end encryption message" on blank chat? ✓ - Network Forum
- Why cant i copy and paste on instagram ✓ - Instagram Forum
3 responses
TrowaD
Posts
2921
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
December 27, 2022
555
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
555
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
555
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
