Is it possible to VLookUp Data between multiple workbooks (12 different workbooks to be exact) in one master sheet?
Below is how I would like to execute the problem.
I have also provided mock-up workbooks. I made them real simple.
I would like the master sheet to find the empty data for the item number. Basically, how can I automatically populate the empty data for each item number in the master sheet. Every item will be different. The 12 workbooks are invoices throughout the year (Jan, Feb, Mar, Apr, etc) and these workbooks have the data needed to fill the master sheet. How is this possible? Or is it not? Please explain.
Master sheet.xlsx
-Contains item number
-Purchase Date
-Sell Date
-Purchase Price
-Sell Price
-Profit Price
The 12 workbooks are the 12 months out of the year, which are invoices.
- Contain the data needed in the master sheet such as sell date, sold price, and profit.
The reason I would like to keep the 12 invoices as workbooks instead of worksheets in 1 big file, is due to the high capacity of item numbers each monthly invoice would have. For example (approximately 500 items in each workbook)
I hope I explained the situation well enough.
I am a basic user at excel.
I have for hours and weeks, actually months, tried to figure this problem out.
But I havent found any sources on the internet, although I have seen the VLook Up how to's on youtube between 2 workbooks, but not the 12 I would like.
Thanks if you can help
HERE ARE THE MOCK-UP FILES
Is this possible? Has it been done?
Thank you.
Bookmarks