Sorry, I see no solution.

Cheers,
--
AP

"Harley Rider" a écrit dans le
message de ...
Sir, Thank you for our reply and suggestion however I am required to have
two columns because I do not want the reason for making the selection to
be
enter on to the form. I need the use to select/make a choice from column
one
due to the info in column two. I would appreciate any other thoughts or
ideal you might have.
"Ardus Petus" wrote:

Your list in Sgeet2 should have 1 column only

You must assign a name (eg: States") to it
(Insertname)

Get back to sheet1
Select rows to be validated by drop-down list
DataValidation
Select List
Enter =States in range box

Et voila!

HTH
--
AP

"Harley Rider" a écrit dans le
message de ...
I would of thought some Excell experts out there would of told me how
to
do
this by now! Can anyone HELP ME? I really need to get this form done
and
my
head is bleeding from all the bangging it in to the wall!!!

"Harley Rider" wrote:

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 don't 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