View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Smatass Smatass is offline
external usenet poster
 
Posts: 8
Default Values from 3 separate drop-down lists entered into single cell

I have 3 columns for 'complaint A', '..B', '..C'. Each of the cells in
those columns has the same drop-down list that contains 5 items. What I want
to do is have the item from the drop down list moved/placed automatically
into a new cell, but I want the other two drop-down lists to have their
selections moved/placed into the same cell as the first drop-down list
without overwriting the first entry. The 3 entries in the single cell would
be comma separated ideally. Does that make sense and is it possible? Any
help is greatly appreciated. Thank you.