| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Pull Down Menu referencing to another page
I have created a workbook with pull down menus. My problem is that I want
the chosen data to stay on a seperate page in specific cells. When you choose a different option from the pull down, I do not want it to over ride the first selection, by display the new data in a seperate cell. Is there a way to do this? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Pull Down Menu referencing to another page
Do you mean you have created an in-cell dropdown selection list from
DataValidationList? A "separate page" is another worksheet? What specific cells? Contiguous or randomly spaced about? How many items in the selection list? What I am thinking of here is event code with Case Select statements to send the selected item to a specific cell on another sheet. Gord Dibben MS Excel MVP On Sun, 3 Feb 2008 11:53:00 -0800, Damdog wrote: I have created a workbook with pull down menus. My problem is that I want the chosen data to stay on a seperate page in specific cells. When you choose a different option from the pull down, I do not want it to over ride the first selection, by display the new data in a seperate cell. Is there a way to do this? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Making a pull down menu like | Excel Discussion (Misc queries) | |||
| Referencing multiple criteria to pull data | Excel Discussion (Misc queries) | |||
| Pull Down Menu Bar | Excel Discussion (Misc queries) | |||
| What is a Conditional pull down menu? | Excel Worksheet Functions | |||
| What is a Conditional pull down menu? | Excel Discussion (Misc queries) | |||
Linear Mode
