G Guest May 16, 2004 #1 I want to input data into a cell and then use that specific data to determine which pick list to use for another cell. Any ideas?
I want to input data into a cell and then use that specific data to determine which pick list to use for another cell. Any ideas?
G Gord Dibben May 17, 2004 #2 Sounds like dependent Data Validation Lists would do the trick. Se Debra Daleish's site for info and instructions. http://www.contextures.on.ca/xlDataVal02.html Gord Dibben Excel MVP
Sounds like dependent Data Validation Lists would do the trick. Se Debra Daleish's site for info and instructions. http://www.contextures.on.ca/xlDataVal02.html Gord Dibben Excel MVP