combinne worksheet from different files
 

I have worksheets in 25 different files. I want to combine/merge them into
one worksheet without having to cut and paste each one. How Ultimately I want
a macro
to perform the task each month.

combinne worksheet from different files
 

Hi Sierra,

See Ron de Bruin's sample code at:

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


---
Regards,
Norman


"sierralightfoot" wrote in
message ...
I have worksheets in 25 different files. I want to combine/merge them into
one worksheet without having to cut and paste each one. How Ultimately I
want
a macro
to perform the task each month.