store the drop down box results in seperate excel sheet

[Guest]

store the drop down box results in seperate excel sheet

 

[Gord Dibben]

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

 

[Trilux_nogo]

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.

 

[Trilux_nogo]

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.