How to Update drop-down list?
Hi Roger
Name Manager - that it is... I remember I used it a few months ago but I
couldn't find it... thanks for your help.
dan
"Roger Govier" wrote:
Hi
For XL2007 it is Data tabData Validation.
But what you really need to do is create a dynamic list for your validation
range.
Supposing your list is on Sheet2, column A then
Formula tabDefine NameNamemyListrefers to
=OFFSET(Sheet2!$A$1,0,0,COUNTA(Sheet2!$A:$A))
In your DV, set the list Source=myList
--
Regards
Roger Govier
|