Home |
Search |
Today's Posts |
#1
|
|||
|
|||
xtract data range from multiple worksheets
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 -- davez ------------------------------------------------------------------------ davez's Profile: http://www.excelforum.com/member.php...o&userid=16685 View this thread: http://www.excelforum.com/showthread...hreadid=399773 |
#2
|
|||
|
|||
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. "davez" wrote: 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 -- davez ------------------------------------------------------------------------ davez's Profile: http://www.excelforum.com/member.php...o&userid=16685 View this thread: http://www.excelforum.com/showthread...hreadid=399773 |
#3
|
|||
|
|||
Hi
See http://www.rondebruin.nl/summary2.htm -- Regards Ron de Bruin http://www.rondebruin.nl "davez" wrote in message ... 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 -- davez ------------------------------------------------------------------------ davez's Profile: http://www.excelforum.com/member.php...o&userid=16685 View this thread: http://www.excelforum.com/showthread...hreadid=399773 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Match function...random search? | Excel Worksheet Functions | |||
Data range properties | Excel Discussion (Misc queries) | |||
data range properties | Excel Discussion (Misc queries) | |||
Pulling data from 1 sheet to another | Excel Worksheet Functions | |||
Extending a Chart Data Series from an Array - Can it be done? | Charts and Charting in Excel |