View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Harley Rider
 
Posts: n/a
Default entering data from a list

I am trying to build a form with certain blocks that will be filled by the
user making a choice from a list of options and reasons for thoses options on
another sheet. Example would look like this

Sheet 1 (The main form)
______ Please pick from the list what State you are from (When they click on
this box, it will give them the choices and reason from sheet2)


Sheet 2
Col 1 Col 2
Data Reason for selection
8 Select this one if you are from CA
9 Select this one if you are from FL
10 Select this one if you are from MA

I dont want the use to be able to enter any thing other than their choice
from the options given. When they make their selection, the number from
sheet2, column 1 would be entered on to sheet 1. Can anyone help me with
this€¦Any help would be greatly appreciated