Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Merging Workbooks | Excel Discussion (Misc queries) | |||
Merging Workbooks | Excel Discussion (Misc queries) | |||
Merging Workbooks | Excel Discussion (Misc queries) | |||
Merging workbooks | Excel Discussion (Misc queries) | |||
merging workbooks | Excel Discussion (Misc queries) |