Create a name (InsertNameDefine...) for the Code column of say a name of
CodeRange and a Refersto value of
=OFFSET(Sheet1!$A$1,,,COUNTA(Sheet1!$A;$A),1)
and in the DV use a type of List and set to =CodeRange
--
HTH
Bob Phillips
(remove nothere from email address if mailing direct)
"ZarrinPour" wrote
in message ...
Hi
I have two Sheets ,in first one i have two columns (Code & Name) and in
second one i have created an invoice Note that the first sheet may be
updated.now in second sheet i want to populate a cell (Data Validation)
with all values of the "Code" column in the fist sheet .how can i do
that.?
Thanks in advance.
Regards.
--
ZarrinPour
------------------------------------------------------------------------
ZarrinPour's Profile:
http://www.excelforum.com/member.php...o&userid=32375
View this thread: http://www.excelforum.com/showthread...hreadid=521370