#1   Report Post  
Posted to microsoft.public.excel.setup
external usenet poster
 
Posts: 8
Default Function Question

If I created a drop down list for States in column €œA€, how can I create a
drop down list in column €œB€ that will allow me to make options of cities
that are only from the state Ive chosen in column €œA€.
--
Jim Patterson
  #2   Report Post  
Posted to microsoft.public.excel.setup
external usenet poster
 
Posts: 35,218
Default Function Question

Is this used with Data|Validation?

If yes, Debra Dalgleish shows how to create dependent lists:
http://contextures.com/xlDataVal02.html


Jim Patterson wrote:

If I created a drop down list for States in column €œA€, how can I create a
drop down list in column €œB€ that will allow me to make options of cities
that are only from the state Ive chosen in column €œA€.
--
Jim Patterson


--

Dave Peterson
  #3   Report Post  
Posted to microsoft.public.excel.setup
external usenet poster
 
Posts: 8
Default Function Question

Works like a champ!!! Thanks Much,
--
Jim Patterson


"Dave Peterson" wrote:

Is this used with Data|Validation?

If yes, Debra Dalgleish shows how to create dependent lists:
http://contextures.com/xlDataVal02.html


Jim Patterson wrote:

If I created a drop down list for States in column €œA€Â, how can I create a
drop down list in column €œB€ that will allow me to make options of cities
that are only from the state I€„¢ve chosen in column €œA€Â.
--
Jim Patterson


--

Dave Peterson

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
Public Function Question Carl Excel Worksheet Functions 7 August 31st 06 08:15 PM
Need some comments on my Utility_Move class module. jchen Excel Worksheet Functions 0 August 21st 06 07:05 PM
MATCH function, exclusion question Paul Lautman Excel Discussion (Misc queries) 4 July 21st 06 04:53 AM
Average function question Sum Limit and marking Excel Worksheet Functions 4 July 8th 06 12:51 AM
clock Wildman Excel Worksheet Functions 2 April 26th 05 10:31 AM


All times are GMT +1. The time now is 09:27 AM.

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

About Us

"It's about Microsoft Excel"