How to VLookup between multiple sheets
Hello members,
Merry Christmas and Happy New Year!
This macro helps me to VLOOKUP between multiple sheets based on Date column (works only for the first column). However, I have to apply to the rest of the data in each column by clicking on + manually. Could you please edit the macro to do it automatically for the whole range of dataset?
Thank you for the time.
sampleVlookup_result.xlsx
Please Login or Register to view this content.
Last edited by Moriexcel; 12-29-2015 at 11:35 AM. Reason: sample result file was added.
it would be possible, if you post excel file with desired result
Kind regards
Leo
Dear Leo, thank you for your reply. Please find the attachments.
Best regards,
Mori
Last edited by Moriexcel; 12-27-2015 at 12:17 PM.
Try like this
Kind regardsPlease Login or Register to view this content.
Leo
Thank you Leo. VLookup works for the whole range now. However, the first problem still remains. I have so many files with different sheets' name. So, each time, I have to type the sheets' name manually and run this code for each workbook (e.g., for another workbook, I have to change 1933121 to another number in the code to be able to do the vlookup). Could you please consider this as well?
Cheers,
Mori
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks