Trying to add names to drop down list in Excel

C

Cosmic

We have a template set up on a separate sheet in the same workbook with a
list of drop down options - I am trying to add to these lists but with very
little success! I am sure the answer is simple but I must be missing it
somewhere!
Thanks
 
B

Bob Phillips

I presume that because it is on another sheet, you are using a range name.
If so, make the name dynamic with a formula like

=OFFSET($A$1,,,COUNT($A:$A),1)

any items added are then automatically picked up.

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)
 
D

davesexcel

=OFFSET(Sheet1!$A$1,0,0,COUNTA(Sheet1!$A:$A),1)

would this be the better solution?
 
B

Bob Phillips

What is the difference?

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)
 
D

davesexcel

the other one didn't seem to work for me, I don't know why...when I
entered it I got a message, something like ..
there is an error do you want to procede anyway?

but the latter formula didn't do that..
 
B

Bob Phillips

Very odd, I didn't and wouldn't expect it as they are the same formula, just
that you explicitly define the rows and columns and the sheet name, I let it
default.

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)
 
Top