View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.programming
Pierre via OfficeKB.com[_2_] Pierre via OfficeKB.com[_2_] is offline
external usenet poster
 
Posts: 122
Default data validation on other sheet

Hi Tom,

Is there also a way to do the following:

ist 2 columns (for example 'client number' and 'name') in the validation
field.
When a client is chosen, only use the client number to fill the cell with.
Thanks,
Pierre


Pierre wrote:
Thanks Tom, works great.
Pierre

Insert = Name = Define

[quoted text clipped - 16 lines]
Thanks,
Pierre


--
Message posted via http://www.officekb.com