Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
ranking query | Excel Discussion (Misc queries) | |||
update data validation list with new entries?? | Excel Discussion (Misc queries) | |||
Entering data on custom forms. | Excel Discussion (Misc queries) | |||
subtotaling and manipulating a list of data | Excel Worksheet Functions | |||
Pulling data from 1 sheet to another | Excel Worksheet Functions |