Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
I am trying to merge/consolidate two spreadsheets into a third spreadsheet.
See example below. <List 1 Name Info Mike Good Guy <List 2 Name Info John Bad Guy I am trying to merge the above lists into a single list that looks like: <List 3 Name Info Mike Good Guy John Bad Guy What is the easiest way to do this? |
#2
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
The easiest way is probably with simple copy and paste. Choose all of the
information on one of the worksheets and use Edit | Copy and then go to the end of the list on the other worksheet and use Edit | Paste. You can then, if you want, choose all of the data and use Data Sort to truly merge the lists aphabetically. If you want to preserve both of the original lists, just copy both lists to an empty sheet. "Mike" wrote: I am trying to merge/consolidate two spreadsheets into a third spreadsheet. See example below. <List 1 Name Info Mike Good Guy <List 2 Name Info John Bad Guy I am trying to merge the above lists into a single list that looks like: <List 3 Name Info Mike Good Guy John Bad Guy What is the easiest way to do this? |
#3
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
Copy/Paste is last resort as the sheets will be updated on a regular basis.
I will also have six spreadsheets with over 100 rows of data in each. I was hoping to find an automatic way to accomplish this. "JLatham" wrote: The easiest way is probably with simple copy and paste. Choose all of the information on one of the worksheets and use Edit | Copy and then go to the end of the list on the other worksheet and use Edit | Paste. You can then, if you want, choose all of the data and use Data Sort to truly merge the lists aphabetically. If you want to preserve both of the original lists, just copy both lists to an empty sheet. "Mike" wrote: I am trying to merge/consolidate two spreadsheets into a third spreadsheet. See example below. <List 1 Name Info Mike Good Guy <List 2 Name Info John Bad Guy I am trying to merge the above lists into a single list that looks like: <List 3 Name Info Mike Good Guy John Bad Guy What is the easiest way to do this? |
#4
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]() http://www.excelforum.com/showthread.php?t=538191 seems related -- steven1001 ------------------------------------------------------------------------ steven1001's Profile: http://www.excelforum.com/member.php...o&userid=30757 View this thread: http://www.excelforum.com/showthread...hreadid=540112 |
#5
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
Let us know if steven1001's lead gives you a solution. There are other
options available, including pretty much being able to record a macro to accomplish it. "Mike" wrote: Copy/Paste is last resort as the sheets will be updated on a regular basis. I will also have six spreadsheets with over 100 rows of data in each. I was hoping to find an automatic way to accomplish this. "JLatham" wrote: The easiest way is probably with simple copy and paste. Choose all of the information on one of the worksheets and use Edit | Copy and then go to the end of the list on the other worksheet and use Edit | Paste. You can then, if you want, choose all of the data and use Data Sort to truly merge the lists aphabetically. If you want to preserve both of the original lists, just copy both lists to an empty sheet. "Mike" wrote: I am trying to merge/consolidate two spreadsheets into a third spreadsheet. See example below. <List 1 Name Info Mike Good Guy <List 2 Name Info John Bad Guy I am trying to merge the above lists into a single list that looks like: <List 3 Name Info Mike Good Guy John Bad Guy What is the easiest way to do this? |
#6
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
I want to use this link but it is unaccessible.
-- Rasoul Khoshravan Azar Civil Engineer, Osaka, Japan "steven1001" wrote: http://www.excelforum.com/showthread.php?t=538191 seems related -- steven1001 ------------------------------------------------------------------------ steven1001's Profile: http://www.excelforum.com/member.php...o&userid=30757 View this thread: http://www.excelforum.com/showthread...hreadid=540112 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Excel 2003 loses the links to other excel spreadsheets on a server | Excel Discussion (Misc queries) | |||
Consolidate multiple spreadsheets into a single workbook | Excel Discussion (Misc queries) | |||
More problems linking spreadsheets | Excel Discussion (Misc queries) | |||
Spreadsheets are cut off when you paste and link? | Excel Worksheet Functions | |||
Excel Charts Linked to Spreadsheets | Charts and Charting in Excel |