A
April
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
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