Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old June 23rd 05, 10:02 PM
peter via OfficeKB.com
 
Posts: n/a
Default 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   Report Post  
Old June 23rd 05, 10:47 PM
Anne Troy
 
Posts: n/a
Default

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   Report Post  
Old June 23rd 05, 11:03 PM
Debra Dalgleish
 
Posts: n/a
Default

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   Report Post  
Old June 24th 05, 11:10 PM
peter via OfficeKB.com
 
Posts: n/a
Default

TENKS EVRYBODY, I CREATED SEARCH FINELLY !

--
Message posted via http://www.officekb.com


Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

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
How do I convert an entire spread sheet form inches to centimeters Ted Excel Discussion (Misc queries) 4 May 3rd 05 02:17 PM
Subset of one sheet on another sheet bxb7668 Excel Discussion (Misc queries) 3 April 25th 05 03:55 PM
Subset of one sheet on another sheet bxb7668 Excel Worksheet Functions 3 April 25th 05 03:55 PM
Impoting data from Sheet 1 to Sheet 2 a-leano Excel Discussion (Misc queries) 1 April 20th 05 01:05 AM
Search for a Sheet Chance224 Excel Discussion (Misc queries) 3 December 14th 04 12:29 AM


All times are GMT +1. The time now is 03:50 AM.

Powered by vBulletin® Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
Copyright ©2004-2019 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"

 

Copyright © 2017