View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
JMN JMN is offline
external usenet poster
 
Posts: 1
Default Multiple responses for a column

Dear helpers,

I have one column where I want my Sales Reps to list their top ten accounts.
What is a good suggestion for organizing this data?

Is there a code for where one adds a comma a new cel is created?
Is there a way to make add in responses appear as a drop down list?

I can just have the user separate the accounts by a comma, I just thought
there might be something better that I do not know about.

Thanks!