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.

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

--
Regards
Roger Govier

George wrote:
> 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.
>

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.



"Roger Govier" wrote:

> 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
>
> --
> Regards
> Roger Govier
>
> George wrote:
> > 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.
> >
> .
>