software

Hello,

I want to select specific rows from a sequential list based on a cell
value.

Example:

Name: Age:
Mark 12
Luke 15
Jon 14
Matthew 12
Fred 12

I want a method of selecting only rows where Age is 12. Note that I
don't want to have to manually select each row, or even sort them by
age and then select each row manually. I want an automatic method that
I could use in a macro eventually.

Thanks for your help!--
m.cain
------------------------------------------------------------------------
m.cain's Profile: www.excelforum.com/member.php...oamp;userid=32773
View this thread: www.excelforum.com/showthread...hreadid=526041Assuming quot;Agequot; is in col B, data from row2 down,
just do a Data gt; Filter gt; Autofilter on col B
then you can select the age from the autofilter droplist in B1
--
Max
Singapore
savefile.com/projects/236895
xdemechanik
---
quot;m.cainquot; gt; wrote in
message ...
gt;
gt; Hello,
gt;
gt; I want to select specific rows from a sequential list based on a cell
gt; value.
gt;
gt; Example:
gt;
gt; Name: Age:
gt; Mark 12
gt; Luke 15
gt; Jon 14
gt; Matthew 12
gt; Fred 12
gt;
gt; I want a method of selecting only rows where Age is 12. Note that I
gt; don't want to have to manually select each row, or even sort them by
gt; age and then select each row manually. I want an automatic method that
gt; I could use in a macro eventually.
gt;
gt; Thanks for your help!
gt;
gt;
gt; --
gt; m.cain
gt; ------------------------------------------------------------------------
gt; m.cain's Profile:
www.excelforum.com/member.php...oamp;userid=32773
gt; View this thread: www.excelforum.com/showthread...hreadid=526041
gt;
Data/Autofilter does it! Record a sample filtering as a macro then you can
edit it to adjust to your needs!

Regards,
Stefi?.cain??ezt ?rta:

gt;
gt; Hello,
gt;
gt; I want to select specific rows from a sequential list based on a cell
gt; value.
gt;
gt; Example:
gt;
gt; Name: Age:
gt; Mark 12
gt; Luke 15
gt; Jon 14
gt; Matthew 12
gt; Fred 12
gt;
gt; I want a method of selecting only rows where Age is 12. Note that I
gt; don't want to have to manually select each row, or even sort them by
gt; age and then select each row manually. I want an automatic method that
gt; I could use in a macro eventually.
gt;
gt; Thanks for your help!
gt;
gt;
gt; --
gt; m.cain
gt; ------------------------------------------------------------------------
gt; m.cain's Profile: www.excelforum.com/member.php...oamp;userid=32773
gt; View this thread: www.excelforum.com/showthread...hreadid=526041
gt;
gt;