extract values from multiple worksheets

[matt5596]

I'm not even sure this is possible but here goes...

I have several hundred seperate worksheets formatted exactly the same. I want to extract the values from specific cells in every worksheet and build a single worksheet with the values extracted.

The attached example includes 2 sample source sheets and a sample result sheet.

[martindwilson]

this is doable with vba but posted in the programming sum forum will probably give you a better response
post it here
http://www.excelforum.com/excel-programming/

[JBeaucaire]

Regarding the 100s of worksheets, are they:

1) in a single workbook
2) individual sheets saved as individual workbooks (1 per book)
3) multiple workbooks but each book has multiple sheets

[JBeaucaire]

Assuming all the sheets are in the same workbook as shown in the example, use this macro:

Please Login or Register  to view this content.

[matt5596]

Regarding the 100s of worksheets, are they:

1) in a single workbook
2) individual sheets saved as individual workbooks (1 per book)
3) multiple workbooks but each book has multiple sheets

Sorry for my delayed response. They are individual sheets saved as individual workbooks.

[JBeaucaire]

Edit the fPath variable in this macro to point to your folder. Also edit the filter in the DIR() command if the files are not *.xlsx files.

Please Login or Register  to view this content.

[matt5596]

"Subscript out of range"

[JBeaucaire]

Debug and do a more thorough job reporting the error. Post your edited version of the macro, too, point out the line with the error.

That error usually means something is spelled wrong, a folder or file or sheet previously defined is now missing...it's looking for something it can't find.

[matt5596]

I ended up using another macro to combine the sheet I needed from each individual workbook into one workbook and then I used the first macro you posted to get my result worksheet. Works great! Thank you.

[JBeaucaire]

If that takes care of your need, please click EDIT in your original post, click GO ADVANCED and set the PREFIX box to SOLVED.