compare 2 x files with same colum labels but different aranged da

[Guest]

My files have the same data
ie File 1
Record Num Value Year.....
101 12 2007

file 2
Year Value Record...
2007 101 11

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

 

[SteveM]

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

 

[Guest]

Maybe I was misunderstood
The 2 Xl file have the same data but layout differently
All colums have a heading in both files . each record has a distict key So
I want to compare the columns that are laouut in different order and spot the
difference