ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Quick Question (https://www.excelbanter.com/excel-discussion-misc-queries/53196-quick-question.html)

Jenn

Quick Question
 
I made up a list of vendors that I use pretty much on a daily basis. Its sort
of like my own phone book. Is there any way that if i needed to get to "S"
That i can do something and put in "S" and all the companies starting with S
will show up?

Peter Belko MOS MI

Quick Question
 
You can use autofiltering (Data - Filter - AutoFilter). From drop down list
select "custom" and set filter condition "s". Excuse me, I don't use English
version.
Before you use this, you need in first row names of columns (name, city,
tel, etc)
peter b.

"Jenn" wrote:

I made up a list of vendors that I use pretty much on a daily basis. Its sort
of like my own phone book. Is there any way that if i needed to get to "S"
That i can do something and put in "S" and all the companies starting with S
will show up?


Bob Phillips

Quick Question
 
This can be done with a combobox from the control toolbox.

--

HTH

RP
(remove nothere from the email address if mailing direct)


"Jenn" wrote in message
...
I made up a list of vendors that I use pretty much on a daily basis. Its

sort
of like my own phone book. Is there any way that if i needed to get to "S"
That i can do something and put in "S" and all the companies starting with

S
will show up?





All times are GMT +1. The time now is 11:42 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com