order rows containing certain text string

nparsons75

Well-known Member
Joined
Sep 23, 2013
Messages
1,159
I have a large spreadsheet containing lots of data. (or will have).

In one of the columns will be text containing either:

in progress
Complete
Outstanding
etc.

I need a macro that when run shows only the rows containing my selected text crtieria. For example I will have a button i can assign the macro to named "Complete". Once pressed only rows containing COMPLETE in a column will be shown.

I have also grouped rows so not sure if this will be a problem.
 

Some videos you may like

Excel Facts

Why are there 1,048,576 rows in Excel?
The Excel team increased the size of the grid in 2007. There are 2^20 rows and 2^14 columns for a total of 17 billion cells.

vds1

Well-known Member
Joined
Oct 5, 2011
Messages
1,193
This sounds to me like auto filter. Have you tried recording the macro ?
 

nparsons75

Well-known Member
Joined
Sep 23, 2013
Messages
1,159
Sometimes the easiest methods stare you in the face and you miss them..... Auto filter works fine, thank you.
 

Watch MrExcel Video

Forum statistics

Threads
1,109,325
Messages
5,528,023
Members
409,799
Latest member
mlewan_ca

This Week's Hot Topics

Top