xtract data range from multiple worksheets

  • Thread starter Thread starter davez
  • Start date Start date
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
 
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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

worksheet cross reference 6
Excel Copy cells from one worksheet to another workseet - increment row & do again 0
copy range to multiple workbooks 4
consolidate workbooks to worksheets in one workbook? 1
Linking multiple worksheets in one workbook 2
Linking data from worksheet to worksheet 6
summary sheet across multiple sheets 3
Relative worksheet reference clarified 4

Back
Top