how to retrieve records ... need help, thanks.

[ªÎ¿°¤H@work]

Dear Sir/Madam,

I have a worksheet as below:

Column A Column B Column C
Row1 David Boy Form1
Row2 Susan Girl Form7
Row3 Mary Girl Form1
Row4 John Boy Form1

I want to retrieve specific record like "Boy" and "Form1", the result should
show out
David Boy Form1
John Boy Form1

How can do this for me by input searching criteria and retrieve suitable
data out?
Thank for helping me.

Regards,
William Chan

 

[Ron Coderre]

We'll need a little more information....

Do you want the matching items:

Filtered in place (hiding the non-matching items)?
Moved to another range of cells?
Copied to another range of cells?
Listed in another range using formulas?
Something else?

--------------------------

Regards,

Ron
Microsoft MVP (Excel)
(XL2003, Win XP)

 

[ªÎ¿°¤H@work]

Many thanks.

We'll need a little more information....

Do you want the matching items:

Filtered in place (hiding the non-matching items)? YES
Moved to another range of cells? NO
Copied to another range of cells? NO
Listed in another range using formulas? NO
Something else? NO

--------------------------

Regards,

Ron
Microsoft MVP (Excel)
(XL2003, Win XP)

 

[Ron Coderre]

Try using an AutoFilter:

First put column headings above your data
Example:
A1:C5 contains...
Name___BG____FormNum
David__Boy___Form1
Susan__Girl__Form7
Mary __Girl__Form1
John___Boy___Form1

Select A1:C5
From the Excel Main Menu:
<data><filter><autofilter>
(That will create drop-down arrows next to each heading.

Click on the BG arrow...Select: Boy
(Now only Boy rows are visible...the others are hidden)

Click on the FormNum arrow...Select: Form1
(Now only Boy/Form1 rows are visible)

When you are done...to display all records:
<data><filter><show all>

For more information on using AutoFilters
see Debra Dalgleish's website:
http://www.contextures.com/xlautofilter01.html

Does that help?
Post back if you have more questions.
--------------------------

Regards,

Ron
Microsoft MVP (Excel)
(XL2003, Win XP)

 

[ªÎ¿°¤H@work]

AutoFilter should be ok and thanks.

How about using VBA to write a form for user input require data and search
suitable record out ?

 

[Ron de Bruin]

See
http://www.rondebruin.nl/easyfilter.htm

 

[???@work]

Thank you for your help.

See
http://www.rondebruin.nl/easyfilter.htm