I have two workbooks, WB1 and WB2. I have attached a workbook with two sheets which represent the two seperates workbooks. I basically need a macro in WB1 that will send the contents of B3:B7 to the corresponding cells in WB2. The problem is that the date in WB1 will change each day so the cells to copy to in WB2 will change according to the date.
How would I go about writing a macro to do this?
I see that in WB2, dates appear in column A & H, now what about a date like April 3rd, in which column would it appear?
If I have helped, Don't forget to add to my reputation (click on the star below the post)
Don't forget to mark threads as "Solved" (Thread Tools->Mark thread as Solved)
Use code tags when posting your VBA code: [code] Your code here [/code]
April 3rd would be in O7, 4th in V7 and so on. Basically, Sunday's in column A, Mondays in col H, Tuesdays in col O etc.
One last question - will the order of numbers in WB1 column A always be the same as WB2 row 6?
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks