#1
|
|||
|
|||
Cell A1 Select car maker = Cell B1 shows menu for car models
OK folks my first ever post!
I have been using the INDEX and MATCH function but can't quite get to what I need... Cell A1 has 3 options to select a car manufacture in the form of a pull down list Ford, BMW, A N Other I want cell B1 to populate a different pull down list dependant the manufacture selected in cell A1 e.g. Cell A1: Ford is picked Cell B1: Displays Ford car menu with 4 options (Focus, Mondeo, Fiesta, S Max) If the user picks the Cell A1 - BMW then I would like cell B1 to show the BMW cars available. Any ideas |
#2
|
||||
|
||||
See, for example: http://windowssecrets.com/forums/sho...474#post861474
__________________
Cheers, Paul Edstein [Fmr MS MVP - Word] |
Tags |
menu selection |
Thread Tools | |
Display Modes | |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Data validation,force cell to be filed with number if respective cell is not empty | nicholes | Excel Programming | 0 | 08-01-2015 09:08 AM |
Can't select a cell in my table | dilorenzoc | Word Tables | 1 | 06-03-2015 05:56 AM |
Assign the value of a cell as a cell reference of another cell in Excel 2010 - How to? | bharathkumarst | Excel | 7 | 10-13-2014 10:25 AM |
Using Input from cell to select data from another sheet | bbhe | Excel | 2 | 09-10-2014 01:50 PM |
VBA code to select one word from a text in a cell and place that word in next cell | Shinaj | Excel | 2 | 05-01-2014 01:50 PM |