ExcelBanter - validation

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - validation - list option (https://www.excelbanter.com/excel-worksheet-functions/223939-validation-list-option.html)

Susan

validation - list option

hello,

Is it possible to create more than 1 list/array in cell B1?
The list chosen would be based on what is in A1?

Thank you,

Gord Dibben

validation - list option

See Debra Dalgleish's site for more on dependent lists.

http://www.contextures.on.ca/xlDataVal02.html

Gord Dibben MS Excel MVP

On Wed, 11 Mar 2009 11:54:52 -0700, Susan
wrote:

hello,

Is it possible to create more than 1 list/array in cell B1?
The list chosen would be based on what is in A1?

Thank you,

All times are GMT +1. The time now is 09:21 PM.