Using a macro to format data: deleted rows with a certain charact

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

Guest

Hi,

I want to create a macro to re-format data that comes in the same format.
For one step, I want to delete all rows that have a certain characteristic -
i.e., a value of "1" in column A. The number of rows is not constant by data
table, however. Is this possible?

Thank you for your help!
 
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

Deleting decreasing data and naming rows. 5
Delete Rows as per Text, Font Color, Font Type, Time Format 11
Converting a “Delete Column” Macro to a “Delete Row” Macro 7
delete rows within a specific range macro 1
Macro to Convert Value to Number, Sort, then Delete 16
Macro for fast deletion of rows that conatin certain data. 2
Macro to remove rows 1
Inserting additional rows and only copying certain columns 1

Back
Top