Hi,

I've a range of data in Sheet 1 in column H1-500. I've used a vlookup to
take information from Sheet 2 matching H1-500 to Column B1-700 and returning
a result in Sheet 1 . What I want to do is identify the data that isn't found
from this Vlookup and add it to the list in Sheet 1

So basically in sheet 2 take the first number in the row (b1) search H1-500
in sheet 1. If it's doent' find it- Copy and paste the row to end of Sheet 1.
(row 501)

Then move to next row in sheet 2 (b2) to do the same search again.

I would like to attempt this myself, but I'm so limited on time I can't even
think where to start.

Any help please?

Carl