Home |
Search |
Today's Posts |
#1
|
|||
|
|||
search form in sheet
I have long column with names and it very difficult to find them.
I lose a lot of time to use the form from “menu / edit “. I want to create search form or something ells in order to find text quickly in column, but I don’t now. |
#2
|
|||
|
|||
Hi, Peter. First make yourself a "form", and then use Data Validation and
Vlookup to accomplish your task. Here is a sample (but ugly) form, which uses both, to demonstrate: http://www.myexpertsonline.com/freedls/pricelist.com Here is Data Validation details: http://www.officearticles.com/excel/...soft_excel.htm And here is Vlookup details: http://www.officearticles.com/excel/...soft_excel.htm ******************* ~Anne Troy www.OfficeArticles.com www.MyExpertsOnline.com "peter via OfficeKB.com" wrote in message ... I have long column with names and it very difficult to find them. I lose a lot of time to use the form from “menu / edit “. I want to create search form or something ells in order to find text quickly in column, but I don’t now. |
#3
|
|||
|
|||
You can use an AutoFilter on your list to find text. There are
instructions in Excel's Help, and he http://www.contextures.com/xlautofilter01.html peter via OfficeKB.com wrote: I have long column with names and it very difficult to find them. I lose a lot of time to use the form from “menu / edit “. I want to create search form or something ells in order to find text quickly in column, but I don’t now. -- Debra Dalgleish Excel FAQ, Tips & Book List http://www.contextures.com/tiptech.html |
#4
|
|||
|
|||
|
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I convert an entire spread sheet form inches to centimeters | Excel Discussion (Misc queries) | |||
Subset of one sheet on another sheet | Excel Discussion (Misc queries) | |||
Subset of one sheet on another sheet | Excel Worksheet Functions | |||
Impoting data from Sheet 1 to Sheet 2 | Excel Discussion (Misc queries) | |||
Search for a Sheet | Excel Discussion (Misc queries) |