Menu

Auto Range Select

Search this Thread

Prev

Previous Post

Next Post

Next

#2

Report Post

Posted to microsoft.public.excel.misc

Don Guillett Don Guillett is offline

Don Guillett is offline

external usenet poster

Posts: 10,124

Default

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

Reply With Quote

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Auto select highest 25 scores.	Terry	Excel Worksheet Functions	14	March 23rd 07 09:09 AM
auto word select	jimmy	Excel Discussion (Misc queries)	1	April 25th 05 01:17 PM
Auto Word Select	jimmy	Excel Discussion (Misc queries)	0	April 25th 05 11:19 AM
Auto Word Select	jimmy	Excel Discussion (Misc queries)	0	April 25th 05 11:19 AM
auto word select	jimmy	Excel Discussion (Misc queries)	0	April 25th 05 11:07 AM

All times are GMT +1. The time now is 12:31 AM.

About Us

"It's about Microsoft Excel"

Contact Us ExcelBanter forum home Privacy Statement