G Guest Nov 13, 2007 #1 I am using vlookup to find accounts from sheet1. What ever vlookup finds I want to delete off sheet1. Any ideas? Thank you.
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 Nov 14, 2007 #2 Formulas can return data but they cannot delete data. You would need VBA, probably event code to clear cells. Gord Dibben MS Excel MVP
Formulas can return data but they cannot delete data. You would need VBA, probably event code to clear cells. Gord Dibben MS Excel MVP
