Combining Excel files into 1 (no merging)
 

Each month I have a number of Excel files populated (each having 1 worksheet
which is labeled, columns/ rows are formatted, so they have blanks in them).
I need to be able to combine them, so that each file becomes a worksheet
within a master file. Any way to do it without moving/ creating a copy each
and every time? Thank you.

Combining Excel files into 1 (no merging)
 

See your other thread

--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm


"Margo" wrote in message ...
Each month I have a number of Excel files populated (each having 1 worksheet
which is labeled, columns/ rows are formatted, so they have blanks in them).
I need to be able to combine them, so that each file becomes a worksheet
within a master file. Any way to do it without moving/ creating a copy each
and every time? Thank you.