I am looking for the best solution to extract and or combine multiple excel workbooks into one sheet. I have been using excel for invoicing but I need to track the services into one sheet. I would also like to add this data to an access table. I've tried saving each file as a CSV but since I'm using merged cells the data is all jumbled. My directory structure is as followed. Customer -> Customer Name -> date of Invoice. For example Customer 1 has a sub directed of 20170826 which contains multiple workbooks. These workbooks contain two work sheets, Work Order and Invoice. I am hoping to pull all the information and have it displayed with headers such as Customer, License plate #, VIN, Year, Make, Model, Mileage, Unit #, Labor description, Parts list, Total $ and so forth.
Any help would be greatly appreciated.
Any help would be greatly appreciated.