store the drop down box results in seperate excel sheet

Is there a question here or are you just handing out information?

If a question then yes, it can be done.


Gord Dibben MS Excel MVP

On Thu, 10 May 2007 12:02:03 -0700, Raj wrote:

store the drop down box results in seperate excel sheet

My guess is he wants to know how to link the results of a dropdown box to a
separate worksheet.

By way of example, say you have a dropdown with three choices, "Africa"
"USA" and "Europe" and another worksheet with three tabs each for one of the
dropdown choices.

The question is, how do you link each tab sheet in the second worksheet to
the results of the dropdown choice in the first?

It's something that has occurred to me, but have found no answer.



"Gord Dibben" <gorddibbATshawDOTca wrote in message
...
Is there a question here or are you just handing out information?

If a question then yes, it can be done.


Gord Dibben MS Excel MVP

On Thu, 10 May 2007 12:02:03 -0700, Raj
wrote:

store the drop down box results in seperate excel sheet

I think I have an idea, will test it later....

Say you put in each cell a condition referencing the result of your
drop-down box. So, you choose "Africa" and the dopbox's linked cell in A1
says Africa.

Go to the second spreadsheet and put a condition. Spmething like
=IF([Spreadsheet1]All!$A$1="Africa",[Spreadsheet1]All!B3, B3) this last
condition keeps the original (or updated) result when you change choices in
the dropdown box.

Remains to be seen if you'll have to close the worksheet every time you
change choices and then reopen it because, otherwise, you might get a
"Worksheet Open" error and it won't update.

Don't know, just occurred to me in the shower, I'm in a rush and will test
it later.



"Trilux_nogo" wrote in message
...
My guess is he wants to know how to link the results of a dropdown box to
a separate worksheet.

By way of example, say you have a dropdown with three choices, "Africa"
"USA" and "Europe" and another worksheet with three tabs each for one of
the dropdown choices.

The question is, how do you link each tab sheet in the second worksheet to
the results of the dropdown choice in the first?

It's something that has occurred to me, but have found no answer.



"Gord Dibben" <gorddibbATshawDOTca wrote in message
...
Is there a question here or are you just handing out information?

If a question then yes, it can be done.


Gord Dibben MS Excel MVP

On Thu, 10 May 2007 12:02:03 -0700, Raj
wrote:

store the drop down box results in seperate excel sheet