multiple workbooks

ColinSully

Board Regular
Joined
May 9, 2002
Messages
69
I have a project that I need help working on. I have a number of different files with a number of worksheet in each. They are all in the excat same format. I need to somehow be able to import certain info from each of these workbooks into one new sheet.

For example each workbook has a "summary" and an "other" sheet. I need to get info from every sheet that is between these two. I need to get data from rows 10 through 30 in columns 2 and 9. All this info can be put in a blank sheet but I want all of the books together on in the one sheet as well. I have no idea how to go about this but if anyone has an idea it would be greatly appreciated.
Thanks.
Colin
 

Excel Facts

Last used cell?
Press Ctrl+End to move to what Excel thinks is the last used cell.
If I understand well what you need, I suggest the following procedure:
- Declare an array of workbooks, including full names of the files (ex. Dim wkArray(9) As String, if you have 10 primary files to import data from)
- Use a For...Next statement, in order to loop through all primary workbooks, including opening of the file, copying the required values (rows 10-30, columns 2-9) and finally closing the file
 
Upvote 0

Forum statistics

Threads
1,213,536
Messages
6,114,213
Members
448,554
Latest member
Gleisner2

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top