xtract data range from multiple worksheets

D

davez

Hi all, what i am looking to do is as follows -

i have a folder, ""C:\test\", which contains multiple workbooks, each
of which contain multiple worksheets, one of which is named "SUMMARY"

i need to extract data from the worksheet named "SUMMARY" within each
workbook - cells D1 TO I1 - & create & paste to a new worksheet in my
master workbook, "NEW_RTGS", listing the extracted data row by row
starting at cell D1.

thanks for any help provided
 
B

bigwheel

OK you're going to need formulae similar to the following:-

In cell D1 of "NEW_RTGS": =[Book1.xls]summary!$D$1
in cell E1 : =[Book1.xls]summary!$E$1
etc
then in cell D2 : =[Book2.xls]summary!$D$1
and so on changing the Book1 and Book2 to the correct workbook name of course.
 
Top