|
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 |
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 |
| All times are GMT +1. The time now is 02:20 AM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com