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