On Nov 16, 9:32 am, stratis wrote:
My files have the same data
ie File 1
Record Num Value Year.....
101 12 2007

file 2
Year Value Record...
2007 101 11
I'm not really sure what you are asking. But if you just want to find
the different values, create a new sheet on file 2 and subtract the
proper file 1 column values from the file 2 columns. Any value not
equal to zero is different. Use conditional formatting to highlight
those cells. No coding required.

SteveM


We are talking about 100 colums
I do have the exact corelation between File a and 1 ie
Column 1 - Column 3
Column2- Column 2
Column 3- column 1

What i want is to run a macro on File 2 and find the rows and cells that are
different form file 1 remeber that the code should be the sama but what we
are most interested are the values. The files have about 100 column long but
I just added the first 3

What I got is compare tools that compare cell by cell but not in a relative
manner ie they require that the colums ar in the same order