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

J

Jon S

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.
 
E

emil

Jon S said:
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.
Click to expand...
 
E

emil

Jon S said:
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.
Click to expand...
 
J

Jon S

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.
 
Top