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 |
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 |
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 |
All times are GMT +1. The time now is 09:30 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com