Hello everyone, please help me create a macro that will run on bookA which will check the latest dates in sheet1, then find the matching date in bookB sheet1 and copy the entire column into workbook at A at the same matching date.
Attached are revelant sample file.
bookA.xlsx
bookB.xlsx
Will Book B be open at the time of running the macro or should it open it for you?
Will the macro be in Book A or a different file altogether?
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]
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks