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
|