Codes needed to copy same one row from more than 300 Excel files
 

I have more tham 300 identical formatted workbooks. I like to copy one row
(same in all work book) to a summary workbook and put those rows one after
another in the Summary.

Thank you for your help.

Nai

Codes needed to copy same one row from more than 300 Excel files
 

Hi,
Look into Ron web

http://www.rondebruin.nl/copy3.htm

if this helps please click yes thanks

"Joe Roberto" wrote:

I have more tham 300 identical formatted workbooks. I like to copy one row
(same in all work book) to a summary workbook and put those rows one after
another in the Summary.

Thank you for your help.

Nai