DELETE ROWS BY USING A IF/THEN QUERY

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

Guest

Is it possible to actually delete a row by using a if,then query? I have
data in a spreadsheet and if there is a particular value in one of the cells
I would like it to delete the row of data.
 
No, you cannot do that with any formula
You'll need some VBA macro code.

HTH
 
Not with just formulas....but you can do it with VBA, or with one of the
features in the ASAP Utilities Add-in, which are available free at
www.asap-utilities.com

Vaya con Dios,
Chuck, CABGx3
 
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

Add a new row in Named Table (Table1) and add data from txtboxes into last empty cells based on header named of the Table1 0
reference to worksheet fails if row deleted 7
Delete Rows using If and Wildcard 2
hidden rows problem 7
Deleting Row 1
Delete Rows using Wildcard 2
Deleting rows 1
Deleting Rows based on a Value 1

Back
Top