| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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. |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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. |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I change the format in a excel drop box? | Excel Discussion (Misc queries) | |||
| How do I set up a conditional cell from a drop down list in Excel | Excel Worksheet Functions | |||
| Can we change font size of values in validation drop down list? | Excel Discussion (Misc queries) | |||
| How do I make other cells dependent on my drop down list? | Excel Discussion (Misc queries) | |||
| is it possible to select and change the values of cells in a minimized excel spread sheet from vba? | Excel Worksheet Functions | |||
Linear Mode
