Bill's is better!!
--
Hope this helps


"Bob Phillips" wrote:

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