Extract data from multiple workbooks into one data table
Hi,
I have approx 400 excel files which contain a variety of data but I want to extract 7 particular cells of data from each and create a simple table of this data in a new workbook (7 columns x 400 rows). Can anyone show me a quick way of doing this. I'm sure it can be done but I cannot find a simple solution anywhere.
All 400 files are saved in "C:\Documents\Data Extraction"
Cell references are as follows.
PIN - I10
Start Easting - D12
Start Northing - F12
End Easting - H12
End Northing - J12:K12 (Merged cell)
Safety Score - D128
Total Score - I129
Re: Extract data from multiple workbooks into one data table
This may get what you want. It looks in the directory for Excel files of any type. The assumption is that the data is on the first sheet of the files in the directory. I don't have any source files, so the code is untested. There might be an issue with the merged cell. If it's a problem let me know.
One spreadsheet to rule them all. One spreadsheet to find them. One spreadsheet to bring them all and at corporate, bind them.
A picture is worth a thousand words, but a sample spreadsheet is more likely to be worked on.
LinkBack URL
About LinkBacks
Extract data from multiple workbooks into one data table
Register To Reply
Bookmarks