Macro to strip out certain rows

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

Guest

Hi
Sorry if this is a simple macro but i am new to them.
I have 11 columns of data (A-K). Certain rows have no data in the cells of
column J. I need a macro to identify and strip out these rows and display
them somewhere else on the worksheet, or in a new worksheet.

Thanks for the help.
 
Filter than column (Data>Filter<Autofilte), select blanks, then cut the
visible rows and paste them elsewhere.
 
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 2013 Merge Data 2
Macro for fast deletion of rows that conatin certain data. 2
Inserting additional rows and only copying certain columns 1
Strip out certain rows that have merged cells 2
Excel Macro for deleting Rows containing dates greater than "today" 0
macro to insert row and type data 2
SELECT PART OF A TEXT IN A CELL 1
Look up match and highlight 1

Back
Top