Macro program to delete rows if its 2nd colomn start with 'F'

  • Thread starter Thread starter minghao.jin
  • Start date Start date
M

minghao.jin

Hi, Could you please help to provide me with a macro script? In data
analysis, I would like to delete a number of rows whose 2nd colomn is
like 'F1, F2, F3, etc' Thanks a lot. (e-mail address removed)
 
I'd record a macro when I applied data|autofilter to that column.

Then filter to show the cells that begin with F.

Then delete those visible rows.

And finally remove the data|autofilter.
 
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

Matching data rows from two different sheets into a new a new one 1
Move data from first 7 rows from one column A into multiple Columnsthen the next 7 rows 2
DELETE DEBIT AND CREDIT FIGURES ROW BY MACRO 7
Need help with an excel macro im trying to make 4
Deleting decreasing data and naming rows. 5
Help with slow Macro 15
Macro to delete rows 3
Converting a “Delete Column” Macro to a “Delete Row” Macro 7

Back
Top