merging workbooks
 

i just installed Ron De Bruin's Merge Add-In and it works like a charm.
However, i have one problem - the worksheets all appear on one worksheet. i
wanted each worksheet to have its own worksheet in the merged file. For
example, if i was merging the file India with 6 worksheets with the file US
with 10 worksheets, i wanted my new merged file to have 16 worksheets. is
this possible? or is there a macro that would cycle through the 1 worksheet,
look at Column B (where the name of the worksheet is located), add a
worksheet with that name and transfer the data to the new worksheet?

thanks in advance for your help.

BDW

merging workbooks
 

Hi April

I will add that to a next version

But I have code on my site that can do it
http://www.rondebruin.nl/fso.htm


--

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




"April" wrote in message ...
i just installed Ron De Bruin's Merge Add-In and it works like a charm.
However, i have one problem - the worksheets all appear on one worksheet. i
wanted each worksheet to have its own worksheet in the merged file. For
example, if i was merging the file India with 6 worksheets with the file US
with 10 worksheets, i wanted my new merged file to have 16 worksheets. is
this possible? or is there a macro that would cycle through the 1 worksheet,
look at Column B (where the name of the worksheet is located), add a
worksheet with that name and transfer the data to the new worksheet?

thanks in advance for your help.

BDW