Does any one know method "checkDeletedRows"?

S

Shlomit

Hi,
Does anyone know method "checkDeletedRows" in VBA?

I have two ranges from two sheets and I need to find the row from rang B
that doesn't contain in rang A according to the value in column A of both
ranges ("the value is "ID")

Thanks,
Shlomit
 
M

Mika Oukka

On Sheet2 create following formula to an extra column to check if the value
exists on Sheet1 or not:

=VLOOKUP(A2;Sheet1!$A$2:$A$100;1;FALSE)

Formula will return #N/A, if Range on Sheet1 does not contain the value in
the Column A.

Regards,

Mika Oukka
 
Top