if someone could please help...

i was trying to compare 2 files with excel, but retain the colum
propertie names. i read everyone's posts and came up with nothing. an
help would be greatly appreciated.


thank

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

What do you mean by compare. Particularly when you say two Excel files.

What does retain the column properties names mean? Do you mean retrieve
rather than retain? If so, then better definition of compare - compare what
to what?

--
Regards,
Tom Ogilvy

"nem " wrote in message
...
if someone could please help...

i was trying to compare 2 files with excel, but retain the column
propertie names. i read everyone's posts and came up with nothing. any
help would be greatly appreciated.


thanks


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

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

With workbooks("file1.xls").Worksheets(1)
set rng1 = .range(.cells(1,1),.cells(rows.count,1).End(xlup))
End With

With workbooks("file2.xls").Worksheets(1)
set rng2 = .range(.cells(1,1),.cells(rows.count,1).End(xlup))
End With

for each cell in rng1
if cell < rng2(cell.row) then
msgbox "there is a difference
exit sub
end if
Next


--
Regards,
Tom Ogilvy

nem wrote in message
...
what i mean by compare is...

i would like to compare information that i have on to seperate workbook
files. each one has the same column headings that i would like to
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 go
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/