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? |
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? |
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