LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #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

 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
ranking query JaimeTimbrell Excel Discussion (Misc queries) 2 February 16th 06 08:09 AM
update data validation list with new entries?? cjtj4700 Excel Discussion (Misc queries) 10 December 12th 05 01:00 AM
Entering data on custom forms. famdamly Excel Discussion (Misc queries) 0 December 10th 05 02:37 PM
subtotaling and manipulating a list of data TJN Excel Worksheet Functions 0 April 27th 05 10:31 PM
Pulling data from 1 sheet to another Dave1155 Excel Worksheet Functions 1 January 12th 05 05:55 PM


All times are GMT +1. The time now is 07:19 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"