In Excel, how do I select rows in which a certain value appears i.

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

Guest

I'm trying to make a macro that will select all rows in which a specific
value appears in a column, copy them, then paste them into another sheet.
Using autofilter only selects specific row numbers in the macro, so that
didn't work for me. Can anyone help with this?
 
If you filter the entire range, autofilter should work and would be the
easiest. Perhaps you have some completely blank rows in your data which
causes only a subset of the range to be filtered. If so, select the
entirearea, then apply the autofilter. You should then be able to use the
approach you have already developed.
 
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

In Excel, how do I select rows in which a certain value appears? 2
Can I send an email too? 3
define Range in vba using contents of a cell that is named 1
Exclude header row when copying autofilter results? (XL2003) 1
Eliminate blanks while copy row and transpose 11
Insert Row also adds formulas and moves cursor 2
Select first cell in active row? 1
Copy Rows based on column value 2

Back
Top