Posted to microsoft.public.excel.programming

neu2me

external usenet poster

Posts: 7

Using Data Validation to Filter Lists

I have a list of cities orgaized alphabetically by state and then by city,
and I have just created a second list of just states. What I want to know is
if there is a way to use data-validation to create a filtered drop-down list
of cities using the state from the second list. Is this possible, and if so
how?

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

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
Data Validation Lists	Sue	Excel Worksheet Functions	5	February 11th 10 03:58 AM
Data Validation Lists	Sue	Excel Worksheet Functions	0	February 10th 10 02:18 PM
Data validation lists	HCS7 via OfficeKB.com	Excel Discussion (Misc queries)	0	November 20th 08 07:35 AM
Data validation with validation lists and combo boxs	Keith	Excel Discussion (Misc queries)	1	October 12th 06 11:08 AM
Data Validation Lists	dzierzekr	Excel Worksheet Functions	1	September 15th 06 08:43 PM

All times are GMT +1. The time now is 10:17 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us