Consolidate Spreadsheets

[Guest]

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?

 

[Guest]

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.

 

[Guest]

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.

 

[steven1001]

http://www.excelforum.com/showthread.php?t=538191 seems relate

 

[Guest]

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.

 

[Guest]

I want to use this link but it is unaccessible.