Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Merging 2 separate spreadsheets into 1 w/ 2 sheets.
I have two separate spreadsheets created.... pg 1-50, and pgs 50+.. how do i
merge the "pg 50+" into the "pg1-50" as just a second sheet, instead of 2 separate files? |
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Merging 2 separate spreadsheets into 1 w/ 2 sheets.
Consider two cases as follows:
1- If you want to add as separate tab: You can copy an entire sheet to another file. right click on the first sheet tab name and select move or copy and select the second file name (It should be open in order to see its name) 2- If you want to add to same sheet: Use Data| Consolidate For more info on Consolidate refer to: http://support.microsoft.com/default.aspx/kb/214270 If it helps, click yes "Gr8 Dane" wrote: I have two separate spreadsheets created.... pg 1-50, and pgs 50+.. how do i merge the "pg 50+" into the "pg1-50" as just a second sheet, instead of 2 separate files? |
#3
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Merging 2 separate spreadsheets into 1 w/ 2 sheets.
Thank you Khosh, your #1 option worked very well, and was just what I was
looking for. Thanks. "Khoshravan" wrote: Consider two cases as follows: 1- If you want to add as separate tab: You can copy an entire sheet to another file. right click on the first sheet tab name and select move or copy and select the second file name (It should be open in order to see its name) 2- If you want to add to same sheet: Use Data| Consolidate For more info on Consolidate refer to: http://support.microsoft.com/default.aspx/kb/214270 If it helps, click yes "Gr8 Dane" wrote: I have two separate spreadsheets created.... pg 1-50, and pgs 50+.. how do i merge the "pg 50+" into the "pg1-50" as just a second sheet, instead of 2 separate files? |
#4
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Merging 2 separate spreadsheets into 1 w/ 2 sheets.
You are welcome and thanks for feedback.
"Gr8 Dane" wrote: Thank you Khosh, your #1 option worked very well, and was just what I was looking for. Thanks. "Khoshravan" wrote: Consider two cases as follows: 1- If you want to add as separate tab: You can copy an entire sheet to another file. right click on the first sheet tab name and select move or copy and select the second file name (It should be open in order to see its name) 2- If you want to add to same sheet: Use Data| Consolidate For more info on Consolidate refer to: http://support.microsoft.com/default.aspx/kb/214270 If it helps, click yes "Gr8 Dane" wrote: I have two separate spreadsheets created.... pg 1-50, and pgs 50+.. how do i merge the "pg 50+" into the "pg1-50" as just a second sheet, instead of 2 separate files? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Merging two spreadsheets | Excel Worksheet Functions | |||
Merging Separate Worksheets into one Workbook | Excel Discussion (Misc queries) | |||
Merging two spreadsheets | Excel Discussion (Misc queries) | |||
merging spreadsheets | Excel Discussion (Misc queries) | |||
Merging different spreadsheets | Excel Discussion (Misc queries) |