View Single Post
  #7   Report Post  
Posted to microsoft.public.excel.misc
DB DB is offline
external usenet poster
 
Posts: 46
Default 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