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

[Guest]

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.

 

[Guest]

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.

 

[Guest]

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.

 

[Guest]

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.