Aggregating Data from Multiple Workbooks in the Same Folder

[blinkzorg]

Hi everyone,

I have a set of state-by-state data, with each state having a separate spreadsheet. They are all in the same format, and I was wondering if there was some way to automate the process of combining data from specific cells in each spreadsheet.

Specifically, I'm working with the IRS Data located here: http://www.irs.gov/taxstats/article/...219931,00.html. I've saved all of the state files in a single folder. I need the final spreadsheet to be a list of states and their corresponding values from cells D4 and E4. Is there any simple way to do this?

Thank you!

[JieJenn]

Try this code. I noticed the file you downloaded is in xls format (Excel 2003 and earlier), so just change the extension and folder directory.

Just an FYI, I didn't consolidate because as an Accountant's, I think it is better to have all the data listed and just do a sum function to consolidate the numbers.

Please Login or Register  to view this content.

[blinkzorg]

Fantastic! Thank you so much! Yeah, the consolidation is easy with the sum function. One last thing, is it possible to also extract the name of the state for each column, or at least the filename?

Edit: Never mind, I've figured it out. Thank you again!