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

On Nov 16, 9:32 am, stratis <stra...@discussions.microsoft.com> 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

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 <stra...@discussions.microsoft.com> 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
>
>