I wanto to complain 2 XL sheets.
Dat is the same but columns are layout in a different order.
Column headings are the same.
All tools thatI found in the knowledge base are based on same layout
comparison.
Want to spot differences between file 1 and file 2

Hi

You could sort both sheets first, so their column order is the same.
Mark all columns>Data>Sort>Select my data has Headers>Options>Left to
Right>OK

Then carry out the comparison.
Do the work on a copy of your original sheets if you want to preserve their
column layout

--
Regards
Roger Govier



"stratis" <(E-Mail Removed)> wrote in message
news:1A0CD49E-AE29-41F5-8CD9-(E-Mail Removed)...
>I wanto to complain 2 XL sheets.
> Dat is the same but columns are layout in a different order.
> Column headings are the same.
> All tools thatI found in the knowledge base are based on same layout
> comparison.
> Want to spot differences between file 1 and file 2
>

Even if the order of the records is the same in both fiiles the Columns are
differently arranged in the 2 files. ie A Column is VALUE in File 1. VALUE is
found in column C in file 2. The order of those files with more than 100
colmns cannot be refixed because they are exports from a closed application.
thats why even if I sort the columns this does not help


"Roger Govier" wrote:

> Hi
>
> You could sort both sheets first, so their column order is the same.
> Mark all columns>Data>Sort>Select my data has Headers>Options>Left to
> Right>OK
>
> Then carry out the comparison.
> Do the work on a copy of your original sheets if you want to preserve their
> column layout
>
> --
> Regards
> Roger Govier
>
>
>
> "stratis" <(E-Mail Removed)> wrote in message
> news:1A0CD49E-AE29-41F5-8CD9-(E-Mail Removed)...
> >I wanto to complain 2 XL sheets.
> > Dat is the same but columns are layout in a different order.
> > Column headings are the same.
> > All tools thatI found in the knowledge base are based on same layout
> > comparison.
> > Want to spot differences between file 1 and file 2
> >
>
>
>

Even if I sorts them its not possible as the columns in the files are
arranged in a different manner

"Roger Govier" wrote:

> Hi
>
> You could sort both sheets first, so their column order is the same.
> Mark all columns>Data>Sort>Select my data has Headers>Options>Left to
> Right>OK
>
> Then carry out the comparison.
> Do the work on a copy of your original sheets if you want to preserve their
> column layout
>
> --
> Regards
> Roger Govier
>
>
>
> "stratis" <(E-Mail Removed)> wrote in message
> news:1A0CD49E-AE29-41F5-8CD9-(E-Mail Removed)...
> >I wanto to complain 2 XL sheets.
> > Dat is the same but columns are layout in a different order.
> > Column headings are the same.
> > All tools thatI found in the knowledge base are based on same layout
> > comparison.
> > Want to spot differences between file 1 and file 2
> >
>
>
>

Hi

That is why I said to Sort the COLUMNS, not the Rows.

If you choose Options on the Sort dialogue, then choose Left to Right, that
sorts the Columns into alphabetic order based on the column heading.

It does not sort the Rows.

--
Regards
Roger Govier



"stratis" <(E-Mail Removed)> wrote in message
news:7887C47F-2A0F-412E-8BBA-(E-Mail Removed)...
> Even if I sorts them its not possible as the columns in the files are
> arranged in a different manner
>
> "Roger Govier" wrote:
>
>> Hi
>>
>> You could sort both sheets first, so their column order is the same.
>> Mark all columns>Data>Sort>Select my data has Headers>Options>Left to
>> Right>OK
>>
>> Then carry out the comparison.
>> Do the work on a copy of your original sheets if you want to preserve
>> their
>> column layout
>>
>> --
>> Regards
>> Roger Govier
>>
>>
>>
>> "stratis" <(E-Mail Removed)> wrote in message
>> news:1A0CD49E-AE29-41F5-8CD9-(E-Mail Removed)...
>> >I wanto to complain 2 XL sheets.
>> > Dat is the same but columns are layout in a different order.
>> > Column headings are the same.
>> > All tools thatI found in the knowledge base are based on same layout
>> > comparison.
>> > Want to spot differences between file 1 and file 2
>> >
>>
>>
>>

This is not wroking ebven if i resort the rows the columns are in different
order


"Roger Govier" wrote:

> Hi
>
> You could sort both sheets first, so their column order is the same.
> Mark all columns>Data>Sort>Select my data has Headers>Options>Left to
> Right>OK
>
> Then carry out the comparison.
> Do the work on a copy of your original sheets if you want to preserve their
> column layout
>
> --
> Regards
> Roger Govier
>
>
>
> "stratis" <(E-Mail Removed)> wrote in message
> news:1A0CD49E-AE29-41F5-8CD9-(E-Mail Removed)...
> >I wanto to complain 2 XL sheets.
> > Dat is the same but columns are layout in a different order.
> > Column headings are the same.
> > All tools thatI found in the knowledge base are based on same layout
> > comparison.
> > Want to spot differences between file 1 and file 2
> >
>
>
>

IN additin i failed to mentioned that file 2 has a number of columns that do
not exist in file 1 . We know and we ignore during comparison. Thats why
column sorting could not be the solutin . i guse colum correlation and then
running a macro could be the solution

"stratis" wrote:

> This is not wroking ebven if i resort the rows the columns are in different
> order
>
>
> "Roger Govier" wrote:
>
> > Hi
> >
> > You could sort both sheets first, so their column order is the same.
> > Mark all columns>Data>Sort>Select my data has Headers>Options>Left to
> > Right>OK
> >
> > Then carry out the comparison.
> > Do the work on a copy of your original sheets if you want to preserve their
> > column layout
> >
> > --
> > Regards
> > Roger Govier
> >
> >
> >
> > "stratis" <(E-Mail Removed)> wrote in message
> > news:1A0CD49E-AE29-41F5-8CD9-(E-Mail Removed)...
> > >I wanto to complain 2 XL sheets.
> > > Dat is the same but columns are layout in a different order.
> > > Column headings are the same.
> > > All tools thatI found in the knowledge base are based on same layout
> > > comparison.
> > > Want to spot differences between file 1 and file 2
> > >
> >
> >
> >