 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
| HomeDiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWordDirectoryUser Groups Related Topics Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ... |
MS Office Forum / Excel / New Users / March 2008how to retrieve records ... need help, thanks.
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 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) > Dear Sir/Madam, > [quoted text clipped - 17 lines] > Regards, > William Chan Many thanks. "Ron Coderre" <ronREMOVETHIScoderre@bigfoot.com> ¼¶¼g©ó¶l¥ó·s»D:ulzlc9viIHA.3448@TK2MSFTNGP04.phx.gbl... > We'll need a little more information.... > [quoted text clipped - 35 lines] >> Regards, >> William Chan 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) > Many thanks. > [quoted text clipped - 39 lines] >>> Regards, >>> William Chan 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 Coderre" <ronREMOVETHIScoderre@bigfoot.com> ¼¶¼g©ó¶l¥ó·s»D:%23VDKr00iIHA.5504@TK2MSFTNGP05.phx.gbl... > Try using an AutoFilter: > [quoted text clipped - 79 lines] >>>> Regards, >>>> William Chan See http://www.rondebruin.nl/easyfilter.htm  SignatureRegards Ron de Bruin http://www.rondebruin.nl/tips.htm > AutoFilter should be ok and thanks. > [quoted text clipped - 83 lines] >>>>> Regards, >>>>> William Chan Thank you for your help. "Ron de Bruin" <rondebruin@kabelfoon.nl> ???????:uETwy%23RjIHA.3740@TK2MSFTNGP03.phx.gbl... > See > http://www.rondebruin.nl/easyfilter.htm [quoted text clipped - 89 lines] >>>>>> Regards, >>>>>> William Chan
|
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.