How do I paste several files together for comparison?

M

Mr.Q

I created seven files that are related to each other and i wanted to put them
together in comparison so how do i put these files togther.

For example:
File#1 is in colum A B C D and i wonder if i could put file # 2 in E F G
H....and so on.

Thank you.
 
K

Ken Wright

Data all the same in each file?

If so then create a single file as follows

A B C D E
File Hdg1 Hdg2 Hdg3 Hdg4
File1 Col1 Col2 Col3 Col4
File1 Col1 Col2 Col3 Col4
File1 Col1 Col2 Col3 Col4
File2 Col1 Col2 Col3 Col4
File2 Col1 Col2 Col3 Col4
File2 Col1 Col2 Col3 Col4
File3 Col1 Col2 Col3 Col4
File3 Col1 Col2 Col3 Col4

Select all the data and create a Pivot table and then use that to compare
the data. See here for some good example of pivot tables:-

http://peltiertech.com/Excel/Pivots/pivotstart.htm
 
Top