Excel 2007 Question

[shilala]

How does one merge two documents to create a single document?

[Darrell]

http://ask.metafilter.com/106144/Combining-a-ton-of-Excel-files-into-one-Excel-file

[bobarian]

How does one merge two documents to create a single document?

Are the data fields exactly the same on both documents? In other words all columns are same on both documents?

[yachties23]

PM sent

[shilala]

Are the data fields exactly the same on both documents? In other words all columns are same on both documents?
no. there is one "common" data field, but each document contains different information (columns) regarding the common field.