| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Data validation
Parameter LegL 25 Thk 3 Length 30 The LegL is validated to 25, 30, 40 etc When LegL=25 i want Thk to validate to 3,4 or 5 When Leg =30 thk to validate to 5,6,or 7 how is this done, its drving me crazy????? -- stee ------------------------------------------------------------------------ stee's Profile: http://www.excelforum.com/member.php...o&userid=31963 View this thread: http://www.excelforum.com/showthread...hreadid=516858 |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Data validation
Hi
Set up a named range of LegL having values of 25,30,40 etc. Set up other named ranges for the values associated with the 25, 30 etc. values of LegL, except that these cannot be just called 25 or 30. I named mine as L_25 with values of 3,4 and 5 and L_30 with values of 5,6,and 7. In cell A1, DataValidationList =LegL In cell A2, DataValidationList =INDIRECT("L_"&A1) -- Regards Roger Govier "stee" wrote in message ... Parameter LegL 25 Thk 3 Length 30 The LegL is validated to 25, 30, 40 etc When LegL=25 i want Thk to validate to 3,4 or 5 When Leg =30 thk to validate to 5,6,or 7 how is this done, its drving me crazy????? -- stee ------------------------------------------------------------------------ stee's Profile: http://www.excelforum.com/member.php...o&userid=31963 View this thread: http://www.excelforum.com/showthread...hreadid=516858 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| From several workbooks onto one excel worksheet | Excel Discussion (Misc queries) | |||
| Data Validation | Excel Worksheet Functions | |||
| data validation lists | Excel Discussion (Misc queries) | |||
| named range, data validation: list non-selected items, and new added items | Excel Discussion (Misc queries) | |||
| Pulling data from 1 sheet to another | Excel Worksheet Functions | |||
Linear Mode
