I would like to do is create a macro that goes into document1, copies data based on the date into document2 based on the date. Is there anyone who can help me with this.
Thank you!!!!
I would like to do is create a macro that goes into document1, copies data based on the date into document2 based on the date. Is there anyone who can help me with this.
Thank you!!!!
Are you asking to have the macro look in document2 based on the date in any particular row, find that same date in doc2 and return "blocked" and "Pickup" from that same row?
ChemistB
My 2?
substitute commas with semi-colons if your region settings requires
Don't forget to mark threads as "Solved" (Edit First post>Advanced>Change Prefix)
If I helped, Don't forget to add to my reputation (click on the little star at bottom of this post)
Forum Rules: How to use code tags, mark a thread solved, and keep yourself out of trouble
The dates will always be in the same column and row for document2. The dates will always be in the same column on document1, however the rows will change (Please see the new attached). Once today passes, it will no longer be displayed on document1. So 9/20/2010 will be gone and cell A4 will start with 9/21/2010.
I would like to be able to look up the values in document1 under "blocked" and "pickup" based on the date and paste into document2 under "blocked" and "pickup" for the same dates.
Is this possible?
Thank you so much for your help!!!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks