what i mean by compare is...

i would like to compare information that i have on to seperate workboo
files. each one has the same column headings that i would like t
compare the other file with...

ex:

file1 column A compared by file2 column A

then, what i meant by retaining the column headings is to be able to g
back and sort the columns by a different column heading...

ex:

sort by column c

thanks again for the reply. take care

--
Message posted from http://www.ExcelForum.com