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

--
Regards
Ken....................... Microsoft MVP - Excel
Sys Spec - Win XP Pro / XL 97/00/02/03

----------------------------------------------------------------------------
It's easier to beg forgiveness than ask permission :-)
----------------------------------------------------------------------------

"Mr.Q" wrote in message
...
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.