Hello everyone,
I would love some assistance with this.
Each month I receive dozens of files - similar to the example I have attached.
Every department sends me their information regarding invoices, While we have the same big file, they only fill in the information regarding their department and send it back to me.
This is the process:
1.) The big file is located at the "Main File" Sheet, when its sent to all department managers the amounts are all blank.
2.) Then, each department manager sends me back their Amounts based on their area, for example: If I am the manager of Florida, I fill in amounts for Kate upton and Bon Govi(I know its Jovi ) and send it back. so at the end, I have dozens of files with information which I now want to combine into my original file with the use of vba (instead of doing dozens of index matches or vlookup's)
3.) you can see an example in the "Other Files" sheet.
So I want to be able to put in all the files in this path: path = "G:\Incomes\Invoices\Formats" and with a macro to go through all files and extract the information.
And I only want to extract amounts where the amount has a value, so that it does not run over the vlookup every time it goes into the loop.
Also, the Florida manager input a reason (column H) - I will need that column to be extracted to
Any Ideas ?
Thank you (:
Bookmarks