LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Crispy
 
Posts: n/a
Default validation list

Hi
I have a data validation drop down list which looks up data from a list of
tables.
What I need is the next cell to to show a dropdown list based on the
selection of the first drop down.
ie:
1st List A B C
A Blue Mon Jan
B Green Tues Feb
C Yellow Wed Mar

the 1st drop down has a list of A,B,C and if B is selected then the 2nd drop
down list displays Mon,Tues,Feb then this selection would be used to do look
ups.

Thank You
 
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
update data validation list with new entries?? cjtj4700 Excel Discussion (Misc queries) 10 December 12th 05 01:00 AM
drop-down list validation won't allow a different worksheet justmetn Excel Worksheet Functions 4 September 15th 05 05:33 PM
Expanding Data validation from List mark hansen Excel Discussion (Misc queries) 2 September 4th 05 01:39 AM
validation list with drop down list of options?? luke013 Excel Worksheet Functions 1 August 31st 05 01:16 PM
list validation using list validation... Patrick G Excel Worksheet Functions 1 December 21st 04 12:37 AM


All times are GMT +1. The time now is 05:34 AM.

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

About Us

"It's about Microsoft Excel"