Comparing data between worksheets

[m5rcc]

I wonder if any one can assist me in what is probably an easy problem.

I have two worksheets, whereby the headers pm each worksheet are the same. the data however may not be. If the entries are different, I have used =IF(ISNA(VLOOKUP(B2,'Master 0202'!B2:B50,1,FALSE)),"New","") to pick up new entries. Fine.

However, those that are not new, i.e. they are both in the old worksheet and the new worksheet, I need to find out whether there is any change in any of the cells. The headers run from columns A to W.

How can I find out if there are any changes in any of the cells in one go? Can I use another VLOOKUP?

Thanks in advance

[Kevin UK]

Hi m5rcc

One way would be, on a new sheet for example:

Please Login or Register  to view this content.

Copy across and down as far as required.

[Palmetto]

Cross posted at Ozgrid