View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Ron de Bruin Ron de Bruin is offline
external usenet poster
 
Posts: 11,123
Default Combining several Excel files into 1

Hi Margo

Start here
http://www.rondebruin.nl/fso.htm


--

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.