Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Pick list on a sheet - multiple rows?
I am using Windows XP with Office 2003.
I need suggestions for the quickest, easiest possible method that requires as few clicks as possible for the following: Multiple users will open a spreadsheet and enter data into a few columns. One column will need a pick list of some sort that will allow the user to only enter certain specified entries (those in the list). Many rows will be used, but the quantity changes every week. Each week the form will be cleared and the entering begins again. I know how to protect the column and unprotect it, etc. The issue is what is the best way to display the pick list? A user form on a dialog box? One single drop down on the sheet that populates the current cell? Any other ideas? What is the best method? Thanks much for any and all input. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
can i wrap rows to form multiple rows per row to fit on 1 sheet? | Excel Discussion (Misc queries) | |||
HOW DO I CREATE A DROPDOWN PICK LIST FROM A VLOOKUP with multiple | Excel Worksheet Functions | |||
Pick value off sheet list for VBA code determination | Excel Discussion (Misc queries) | |||
How do I pick up only the rows with a non-null key column on a separate sheet? | Excel Worksheet Functions | |||
Making pick list conditional on selection from previous pick list | Excel Discussion (Misc queries) |