transfer rows between workbooks automatically
 

I have about 100 excel spreadsheets with one line of information in the top
row on the first sheet in a folder. I need to copy the one line from each
workbook and put them in another workbook all on the same sheet in different
rows. Is there anyway to automate this?

Thanks for any help.

transfer rows between workbooks automatically
 

Hi BillyRogers

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

--
Regards Ron de Bruin
http://www.rondebruin.nl


"BillyRogers" wrote in message ...
I have about 100 excel spreadsheets with one line of information in the top
row on the first sheet in a folder. I need to copy the one line from each
workbook and put them in another workbook all on the same sheet in different
rows. Is there anyway to automate this?

Thanks for any help.

transfer rows between workbooks automatically
 

thanks for the help

"Ron de Bruin" wrote:

Hi BillyRogers

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

--
Regards Ron de Bruin
http://www.rondebruin.nl


"BillyRogers" wrote in message ...
I have about 100 excel spreadsheets with one line of information in the top
row on the first sheet in a folder. I need to copy the one line from each
workbook and put them in another workbook all on the same sheet in different
rows. Is there anyway to automate this?

Thanks for any help.