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