Merging Separate Worksheets into one Workbook
 

I have about 90 separate Excel files each with one worksheet. I can manually
open these and move each worksheet into a master file but this is time
consuming. Is there an easier way to move all these files into one workbook
so that I end up with only one file containing 90 individual worksheets?

I am doing this at work so I am not sure if I am allowed to copy macros for
security purposes. In addition, I am not very familiar with macros but need
to learn. If someone knows of standard Excel commands to do this (maybe an
add-in) that would be great. Otherwise, I welcome all suggestions.

Sincerely,
Jim

Merging Separate Worksheets into one Workbook
 

See this page Jim
http://www.rondebruin.nl/copy3.htm

I am not very familiar with macros
Read this first
http://www.mvps.org/dmcritchie/excel/getstarted.htm


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



"Jim Johnson" wrote in message ...
I have about 90 separate Excel files each with one worksheet. I can manually
open these and move each worksheet into a master file but this is time
consuming. Is there an easier way to move all these files into one workbook
so that I end up with only one file containing 90 individual worksheets?

I am doing this at work so I am not sure if I am allowed to copy macros for
security purposes. In addition, I am not very familiar with macros but need
to learn. If someone knows of standard Excel commands to do this (maybe an
add-in) that would be great. Otherwise, I welcome all suggestions.

Sincerely,
Jim