software

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


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: www.excelforum.com/member.php...oamp;userid=31708
View this thread: www.excelforum.com/showthread...hreadid=537157I 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)

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

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

would this be the better solution?--
davesexcel------------------------------------------------------------------------
davesexcel's Profile: www.excelforum.com/member.php...oamp;userid=31708
View this thread: www.excelforum.com/showthread...hreadid=537157What is the difference?

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

quot;davesexcelquot; gt; wrote
in message ...
gt;
gt; =OFFSET(Sheet1!$A$1,0,0,COUNTA(Sheet1!$A:$A),1)
gt;
gt; would this be the better solution?
gt;
gt;
gt; --
gt; davesexcel
gt;
gt;
gt; ------------------------------------------------------------------------
gt; davesexcel's Profile:
www.excelforum.com/member.php...oamp;userid=31708
gt; View this thread: www.excelforum.com/showthread...hreadid=537157
gt;

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: www.excelforum.com/member.php...oamp;userid=31708
View this thread: www.excelforum.com/showthread...hreadid=537157Very 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)

quot;davesexcelquot; gt; wrote
in message ...
gt;
gt; the other one didn't seem to work for me, I don't know why...when I
gt; entered it I got a message, something like ..
gt; there is an error do you want to procede anyway?
gt;
gt; but the latter formula didn't do that..
gt;
gt;
gt; --
gt; davesexcel
gt;
gt;
gt; ------------------------------------------------------------------------
gt; davesexcel's Profile:
www.excelforum.com/member.php...oamp;userid=31708
gt; View this thread: www.excelforum.com/showthread...hreadid=537157
gt;