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

http://www.contextures.com/xlDataVal01.html

If you are adding names to a list you will have to change the range in
your named range, I assume you are using a named range for your data,
validation,list
the above site might help you


--
davesexcel


------------------------------------------------------------------------
davesexcel's Profile: http://www.excelforum.com/member.php...o&userid=31708
View this thread: http://www.excelforum.com/showthread...hreadid=537157

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)

"Cosmic" wrote in message
...
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

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

would this be the better solution?


--
davesexcel


------------------------------------------------------------------------
davesexcel's Profile: http://www.excelforum.com/member.php...o&userid=31708
View this thread: http://www.excelforum.com/showthread...hreadid=537157

What is the difference?

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

"davesexcel" wrote
in message ...

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

would this be the better solution?


--
davesexcel


------------------------------------------------------------------------
davesexcel's Profile:
http://www.excelforum.com/member.php...o&userid=31708
View this thread: http://www.excelforum.com/showthread...hreadid=537157

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..


--
davesexcel


------------------------------------------------------------------------
davesexcel's Profile: http://www.excelforum.com/member.php...o&userid=31708
View this thread: http://www.excelforum.com/showthread...hreadid=537157

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)

"davesexcel" wrote
in message ...

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..


--
davesexcel


------------------------------------------------------------------------
davesexcel's Profile:
http://www.excelforum.com/member.php...o&userid=31708
View this thread: http://www.excelforum.com/showthread...hreadid=537157