validation-list
Dear Sirs,
How may have a validation list depend on other cell? for example if A1 is 1 then B1 can be: Mike, Jullie, peter; and if A1 is 2 then B1 can be: mary, frank, Jessica. thank you for your help |
There are instructions here for creating dependent data validation lists:
http://www.contextures.com/xlDataVal02.html Keyvan wrote: Dear Sirs, How may have a validation list depend on other cell? for example if A1 is 1 then B1 can be: Mike, Jullie, peter; and if A1 is 2 then B1 can be: mary, frank, Jessica. thank you for your help -- Debra Dalgleish Excel FAQ, Tips & Book List http://www.contextures.com/tiptech.html |
All times are GMT +1. The time now is 08:20 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com