Auto Range Select
 

Hi Guys,

This venue is the finest source of information and assistance that I have
ever encountered, and I would like to thank, those that take the time to
help, those of us that are in need of assistance. It's truly appreciated.

I have a spread sheet that is a list of issues. In column "A" I have the
status of the line items: (Unassigned, In Process, Closed, Action, etc...).
I find myself frequently sorting this list by column A , then selecting all
In Process and Action entries(ROWS) and sorting them by other data within
the row. This puts the list in the order of the issue followed by the
current action. I would like to automate this so that the macro will select
only the In Process and Action rows, then do the sort.

How can I select rows based on what is in a column?

Thanks again, for you help,
Craig

Auto Range Select
 

datafilterautofilter

--
Don Guillett
SalesAid Software

"C Brandt" wrote in message
...
Hi Guys,

This venue is the finest source of information and assistance that I have
ever encountered, and I would like to thank, those that take the time to
help, those of us that are in need of assistance. It's truly appreciated.

I have a spread sheet that is a list of issues. In column "A" I have the
status of the line items: (Unassigned, In Process, Closed, Action,
etc...).
I find myself frequently sorting this list by column A , then selecting
all
In Process and Action entries(ROWS) and sorting them by other data within
the row. This puts the list in the order of the issue followed by the
current action. I would like to automate this so that the macro will
select
only the In Process and Action rows, then do the sort.

How can I select rows based on what is in a column?

Thanks again, for you help,
Craig