How do I get a drop-down list to change other cells in Excel?
 

Ok, I have alot of data in one worksheet, and I want to import it into
another worksheet by using a dropdown list of some sort. What I would like to
have is a dropdown list with the names of the different items in the other
chart, and then when an item is selected it imports all the data of the item
to a certain place in the same chart as the dropdown list is in (I hope that
was clear enough ;)). What would be the best way to accomplish this?

Thanks in advance.

How do I get a drop-down list to change other cells in Excel?
 

"Jon S" wrote:

Ok, I have alot of data in one worksheet, and I want to import it into
another worksheet by using a dropdown list of some sort. What I would like to
have is a dropdown list with the names of the different items in the other
chart, and then when an item is selected it imports all the data of the item
to a certain place in the same chart as the dropdown list is in (I hope that
was clear enough ;)). What would be the best way to accomplish this?

Thanks in advance.

How do I get a drop-down list to change other cells in Excel?
 

"Jon S" wrote:

Ok, I have alot of data in one worksheet, and I want to import it into
another worksheet by using a dropdown list of some sort. What I would like to
have is a dropdown list with the names of the different items in the other
chart, and then when an item is selected it imports all the data of the item
to a certain place in the same chart as the dropdown list is in (I hope that
was clear enough ;)). What would be the best way to accomplish this?

Thanks in advance.


"Emil" wrote:

Try with "validation" from "Data" menu, choose "List" in "Allow" Dropdown list box and follow the steps.
success

How do I get a drop-down list to change other cells in Excel?
 

I have created a drop-down list, thats not the problem. The next step is when
I click on something in the list I want to import something like 2*8 cells
from another worksheet to somewhere in the current worksheet.

"emil" wrote:



"Jon S" wrote:

Ok, I have alot of data in one worksheet, and I want to import it into
another worksheet by using a dropdown list of some sort. What I would like to
have is a dropdown list with the names of the different items in the other
chart, and then when an item is selected it imports all the data of the item
to a certain place in the same chart as the dropdown list is in (I hope that
was clear enough ;)). What would be the best way to accomplish this?

Thanks in advance.


"Emil" wrote:

Try with "validation" from "Data" menu, choose "List" in "Allow" Dropdown list box and follow the steps.
success