Hi there,

I need to match two worksheets and work out what appears in one and
not the other.

The match criteria should be variable. Like I only it to find a match
if the row cells in columns B, C, D, E and S match,

I want to check that whats in Sheet 2 is in sheet 1. there could be
duplicates which is absolutely fine but the macro would need to
consider this. Also I need to check that whats in sheet 2 is in sheet
1.

This will highlight items I do not have in my sheets.....

I hope someone can help.

Thanks so much

Andrea