Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
varying validation info based on preceding info
want to create a drop down list where the info varies based from previous
input. For example I have a cylinder that varies in bore size, i select that size from a drop down using validation. Next I need to select rod size from a drop down, the problem is the rod sized vary depending on the bore of the cylinder. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
varying validation info based on preceding info
You want to use dependent drop down lists. See this for an idea:
http://contextures.com/xlDataVal02.html Biff "georgejl" wrote in message ... want to create a drop down list where the info varies based from previous input. For example I have a cylinder that varies in bore size, i select that size from a drop down using validation. Next I need to select rod size from a drop down, the problem is the rod sized vary depending on the bore of the cylinder. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I get info from a cell based on criteria from another cell | Excel Worksheet Functions | |||
data validation list should have opt. to select based on criteria | Excel Worksheet Functions | |||
can i create formula giving totals based on financial & text info | Excel Discussion (Misc queries) | |||
Validation Based on a Date | Excel Worksheet Functions | |||
Calendar based on varying information/ Pivot Table General | Charts and Charting in Excel |