Hi

You could sort both sheets first, so their column order is the same.
Mark all columnsDataSortSelect my data has HeadersOptionsLeft to
RightOK

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" wrote in message
...
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