If data is returned then delete data

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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

Thank you.
 
Formulas can return data but they cannot delete data.

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


Gord Dibben MS Excel MVP
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

EXCEL - IF(IFERROR(VLOOKUP question 0
Dynamic col_index_num in VLOOKUP? 5
Vlookup and If statement help 1
vlookup returns na 7
Set non-continuous PrintArea via Function / Name 0
Vlookups to return a N/A value 3
blank cell return vs. a 0 8
Vlookup not returning correct value 4

Back
Top