Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How do I combine Exel workbooks?
I have 2 Excel workboos that I want to merge or combine into one set of
worksheets. Can this bedone without copying each sheet? |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How do I combine Exel workbooks?
The only other options I could think of are using formulas (not really
recommended) or programmatically using VBA. Are you adversed to copy/pasting? -- Zack Barresse "Kman" wrote in message ... I have 2 Excel workboos that I want to merge or combine into one set of worksheets. Can this bedone without copying each sheet? |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How do I combine Exel workbooks?
On May 5, 1:13 pm, Kman wrote:
I have 2 Excel workboos that I want to merge or combine into one set of worksheets. Can this bedone without copying each sheet? If you just want all the sheets in their current form, but in one file....the easiest way is probably drag-n-drop. Have both files open, and nothing else. Menu: Window-Arrange-Horizontal (any will work, horizontal will be easiest to see if there are a lot of sheets) Then select all the sheets in one file, drag them to the other one. If they need to be in a certain order, drag them into order. Save. It will automatically rename any duplicate sheet names with a "(2)" at the end. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
combine several workbooks without opening | Excel Discussion (Misc queries) | |||
how to combine workbooks or spreadsheets in to one???? | Excel Worksheet Functions | |||
How do I merge/combine different workbooks with different sheets | Excel Worksheet Functions | |||
How do I combine five Excel 2003 workbooks? | Excel Worksheet Functions | |||
Combine many exel files to one | Excel Worksheet Functions |