Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do you merge the sheets in two files?
Hi,
I have two spreadsheets with about 30 sheet tabs in each of them. Is there a simple way to merge the 30 sheet tabs of one file into the other so I'm left with one file of 60 tabs? I know you can copy one sheet to another workbook by right-clicking the tab and selecting "Move or copy" and then selecting the book you want to copy the tab into, but is there a simple way to merge every sheet at once or by macro? Any help would be much appreciated. Thanks, Kim |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do you merge the sheets in two files?
In . com, Kim
spake thusly: I have two spreadsheets with about 30 sheet tabs in each of them. Is there a simple way to merge the 30 sheet tabs of one file into the other so I'm left with one file of 60 tabs? I know you can copy one sheet to another workbook by right-clicking the tab and selecting "Move or copy" and then selecting the book you want to copy the tab into, but is there a simple way to merge every sheet at once or by macro? You can select multiple tabs at once to move or copy. Just select the first in the series, then hold down the shift key, then click on the last in the series. All selected will be highlighted. Then right-click your pointer and choose Move or Copy. -dman- |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do you merge the sheets in two files?
Thanks Ross - why didn't I think of that?
:-) Dallman Ross wrote: In . com, Kim spake thusly: I have two spreadsheets with about 30 sheet tabs in each of them. Is there a simple way to merge the 30 sheet tabs of one file into the other so I'm left with one file of 60 tabs? I know you can copy one sheet to another workbook by right-clicking the tab and selecting "Move or copy" and then selecting the book you want to copy the tab into, but is there a simple way to merge every sheet at once or by macro? You can select multiple tabs at once to move or copy. Just select the first in the series, then hold down the shift key, then click on the last in the series. All selected will be highlighted. Then right-click your pointer and choose Move or Copy. -dman- |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Merge worksheets from separate files into one workbook. | Excel Discussion (Misc queries) | |||
merge sheets | Excel Discussion (Misc queries) | |||
Inserting Sheets from multiple files | Excel Discussion (Misc queries) | |||
workbook sheets into separate files | Excel Worksheet Functions | |||
calculating excel spreadsheet files for pensions and life insurance (including age calculation sheets) | Excel Worksheet Functions |