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?

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?