View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
ZarrinPour
 
Posts: n/a
Default populating DropDown with Values Of a Column in another Sheet.


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