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

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

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

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

compare 2 x files with same colum labels but different aranged
 

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

"SteveM" wrote:

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