ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Secondary List (https://www.excelbanter.com/excel-discussion-misc-queries/88242-secondary-list.html)

Mike

Secondary List
 
Okay, I'm wanting to have two different lists that are created from the
validation tool, but one is dependant upon the other.

For example, the best example I can think of is car makes and models. In
one drop down list, I want a list of car makes. In my secondary list, I want
a list of all the models based on the make selected. Does this make sense?
You'd select the first drop down list and select "Honda", and then the second
list automatically updates with "Accord", "Civic", etc. for my selction.

If you have any thoughts, I'd really appreciate it! If you need more info,
also, just let me know!

RAZA

Secondary List
 

HI MIKE

I CAN GIVE YOU LINK THAT WILL HELP YOU SOLVE YOUR PROBLEM

THE WORKBOOK NAME IS VALIDATION AND SHEET NAME IS "LINKED LIST"

http://www.ozgrid.com/Excel/data-validation.htm

REGARDS
RAZA


--
RAZA
------------------------------------------------------------------------
RAZA's Profile: http://www.excelforum.com/member.php...o&userid=34186
View this thread: http://www.excelforum.com/showthread...hreadid=541413



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

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