Re: Get specific cell data from multiple workbooks for import into MS Access
a couple of years ago I was tasked by a client to import some 10000 spreadsheets generated over a 5 year period.
During that time the format changed - rows were added or deleted so the first 'item' was not on the same row
additional columns were added. Some values were 'annotated'. in some, numbers had been entered as decimals whilst in others they were integers. All depended on who had created the invoice.
In all, I identified some 150 'variants'.
My point is, check that your earliest invoice has exactly the same structure and layout as your last one and do spot checks in between.
If you are confident the layout etc is consistent, you can create some code in vba to loop through the files, importing them one by one.
A little thanks goes a long way. If you have found this post useful, please tick the thanks button