data Val & dynamic ranges

[Dave]

I have a simple workbook with 4 worksheets
The first worksheet is a database list
It consists of 5 columns

Col A, Col B and Col C have data valadation drop down
lists to make a selection.

Col A of the first worksheet is poplulated by a simple
drop down data valadation list.

Col B is populated by a drop down data valadation list
with its selections given by an indirect ref to col A.
=indirect($A2)in the refers to box.

Col C is populated by a drop down data valadation list
with its selections given by an indirect ref to col B.
=indirect($B2)in the refers to box.

for example:
Col A Col B Col C
sheetgoods melamine specific material
plywood
mdf

It all works fine if I use standard names for the
different col selection ranges.

It fails when I try to make the ranges dynamic

ex: =offset(sheet2!$A2,0,0,COUNTA(sheet2!$A:$A),1) in the
refers to box

I get the window in the cell with the arrow, but no list

I have been careful to use the Col A names COl B names in
the names in workbook window when I try creating the
dynamic ranges.

I am using Excel 2000

Thanks in advance

 

[Debra Dalgleish]

There's a workaround for dynamic lists here:

http://www.contextures.com/xlDataVal02.html#Dynamic

 

[Dave]

Thank you I had forgotten

-----Original Message-----
There's a workaround for dynamic lists here:

http://www.contextures.com/xlDataVal02.html#Dynamic



--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html

.