Who's Bill?
--
HTH
Bob Phillips
(remove nothere from email address if mailing direct)
"JudithJubilee" wrote in message
...
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