If data is returned then delete data

L

LiveUser

I am using vlookup to find accounts from sheet1. What ever vlookup finds I
want to delete off sheet1. Any ideas?

Thank you.
 
G

Gord Dibben

Formulas can return data but they cannot delete data.

You would need VBA, probably event code to clear cells.


Gord Dibben MS Excel MVP
 
Top