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
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