hi
i am not aware that you can do that. but as an alternative you might try
dependent dropdowns sometimes called cascading combos.
you didn't say if you were using data validation, sheet combos or form
combos(they are all drop downs) so i'll guess data validations. see this site
for details. http://www.contextures.com/xlDataVal02.html
Want to reply to this thread or ask your own question?
You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.