Compare data on two tabs and populate diffrences on new tab

[robertguy]

Hi,

What I’m tying to achive is to compare data on two worksheets called ‘Old’ and ‘New’ and to populate the diffrence on another worksheet called ‘Diff’ – see attached file where I have manually added the differences onto the ‘Diff’ tab.

Is it possible via VBA or Vlookups to achive this and if so I would be very gratful for any assistance in this matter

Many thanks in advance


Rob

N.B. Excel version 2007

[AB33]

Rob,
Which column/s do you use for a match?

[AB33]

According to the output sheet, you used the 4 columns for a match. If you have over 4 columns, I need to change the code.

[robertguy]

AB33

EXCELLENT !! just what I wanted, many thanks for all your help and assistance

Thanks again Rob