View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Tom Ogilvy Tom Ogilvy is offline
external usenet poster
 
Posts: 6,953
Default Two columns combined into one dropdownlist

create a fourth location that has all the data and point your validation list
at this location.

--
Regards,
Tom Ogilvy


"OTS" wrote:

Hi.
I've got two columns containing data. A third coulmn can only contain data
from those two. What I need to do is, when adding validation to the third
column, add the data registerd in column 1 to the data in column 2 so that I
get a list to choose from in the dropdownlist in column 3.
Anyone got any idea on how to solve this?