Expand list in Excel.

[George]

Hi.
I had made a list menu (Validation data, drop down list etc.) in an Excel
sheet. I would like now to expand (to add new cells with extra data) to the
list. I tried to do this but I couldn’t .
Is it possible ? How?
(I don’t want to write the total workbook again from the beginning)
Thank you.

 

[Roger Govier]

Hi George

make your validation list dynamic
Supposing your validation list is on Sheet2 in column A
Insert>name>Define>
Name myList
Refers to =Sheet2!$A$1:INDEX(Sheet2!$A:$A,COUNTA(Sheet2!$A:$A))

In your Data Validation, List =myList

For more information on Dynamic Lists take a look at
http://www.contextures.com/xlDataVal15.html

and
http://www.contextures.com/xlNames01.html#Dynamic

 

[George]

Thank you Roger.
I will read and I will try to apply the procedure you gave me.( I've
recently upgrade to Excel 2007 and I didn’t find yet the:
insert-name-define.)
If I have understood right this procedure can be applied to an existing
list. Is it?
Thanks again.