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?
|