software

I am trying to merge/consolidate two spreadsheets into a third spreadsheet.
See example below.

lt;List 1gt;
Name Info
Mike Good Guy

lt;List 2gt;
Name Info
John Bad Guy

I am trying to merge the above lists into a single list that looks like:

lt;List 3gt;
Name Info
Mike Good Guy
John Bad Guy

What is the easiest way to do this?

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.

quot;Mikequot; wrote:

gt; I am trying to merge/consolidate two spreadsheets into a third spreadsheet.
gt; See example below.
gt;
gt; lt;List 1gt;
gt; Name Info
gt; Mike Good Guy
gt;
gt; lt;List 2gt;
gt; Name Info
gt; John Bad Guy
gt;
gt; I am trying to merge the above lists into a single list that looks like:
gt;
gt; lt;List 3gt;
gt; Name Info
gt; Mike Good Guy
gt; John Bad Guy
gt;
gt; What is the easiest way to do this?

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.

quot;JLathamquot; wrote:

gt; The easiest way is probably with simple copy and paste. Choose all of the
gt; information on one of the worksheets and use Edit | Copy and then go to the
gt; end of the list on the other worksheet and use Edit | Paste.
gt;
gt; You can then, if you want, choose all of the data and use Data Sort to truly
gt; merge the lists aphabetically.
gt;
gt; If you want to preserve both of the original lists, just copy both lists to
gt; an empty sheet.
gt;
gt; quot;Mikequot; wrote:
gt;
gt; gt; I am trying to merge/consolidate two spreadsheets into a third spreadsheet.
gt; gt; See example below.
gt; gt;
gt; gt; lt;List 1gt;
gt; gt; Name Info
gt; gt; Mike Good Guy
gt; gt;
gt; gt; lt;List 2gt;
gt; gt; Name Info
gt; gt; John Bad Guy
gt; gt;
gt; gt; I am trying to merge the above lists into a single list that looks like:
gt; gt;
gt; gt; lt;List 3gt;
gt; gt; Name Info
gt; gt; Mike Good Guy
gt; gt; John Bad Guy
gt; gt;
gt; gt; What is the easiest way to do this?


www.excelforum.com/showthread.php?t=538191 seems related--
steven1001
------------------------------------------------------------------------
steven1001's Profile: www.excelforum.com/member.php...oamp;userid=30757
View this thread: www.excelforum.com/showthread...hreadid=540112Let 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.

quot;Mikequot; wrote:

gt; Copy/Paste is last resort as the sheets will be updated on a regular basis.
gt; I will also have six spreadsheets with over 100 rows of data in each. I was
gt; hoping to find an automatic way to accomplish this.
gt;
gt; quot;JLathamquot; wrote:
gt;
gt; gt; The easiest way is probably with simple copy and paste. Choose all of the
gt; gt; information on one of the worksheets and use Edit | Copy and then go to the
gt; gt; end of the list on the other worksheet and use Edit | Paste.
gt; gt;
gt; gt; You can then, if you want, choose all of the data and use Data Sort to truly
gt; gt; merge the lists aphabetically.
gt; gt;
gt; gt; If you want to preserve both of the original lists, just copy both lists to
gt; gt; an empty sheet.
gt; gt;
gt; gt; quot;Mikequot; wrote:
gt; gt;
gt; gt; gt; I am trying to merge/consolidate two spreadsheets into a third spreadsheet.
gt; gt; gt; See example below.
gt; gt; gt;
gt; gt; gt; lt;List 1gt;
gt; gt; gt; Name Info
gt; gt; gt; Mike Good Guy
gt; gt; gt;
gt; gt; gt; lt;List 2gt;
gt; gt; gt; Name Info
gt; gt; gt; John Bad Guy
gt; gt; gt;
gt; gt; gt; I am trying to merge the above lists into a single list that looks like:
gt; gt; gt;
gt; gt; gt; lt;List 3gt;
gt; gt; gt; Name Info
gt; gt; gt; Mike Good Guy
gt; gt; gt; John Bad Guy
gt; gt; gt;
gt; gt; gt; What is the easiest way to do this?

I want to use this link but it is unaccessible.
--
Rasoul Khoshravan Azar
Civil Engineer, Osaka, Japanquot;steven1001quot; wrote:

gt;
gt; www.excelforum.com/showthread.php?t=538191 seems related
gt;
gt;
gt; --
gt; steven1001
gt; ------------------------------------------------------------------------
gt; steven1001's Profile: www.excelforum.com/member.php...oamp;userid=30757
gt; View this thread: www.excelforum.com/showthread...hreadid=540112
gt;
gt;