Merging Excel Spreadsheets

[greg.cichocki]

Hi guys, I am looking for some insight into merging two excel spreadsheets, but after searching around I've seen the answer to a question I don't have.

I am trying to merge two spreadsheets with similar column headers E.g. location, dollar amounts, name, etc. but different data in each one (aka 20 suppliers in one, and 20 in the other) how would I go about combining these spreadsheets so I have 1 spreadsheet with 40 suppliers?

 

[VoG]

If they are different sheets within the same workbook see http://msdn.microsoft.com/en-us/library/cc793964.aspx

Otherwise see http://msdn.microsoft.com/en-us/library/gg549168.aspx

 

[greg.cichocki]

Thank you for your help.