| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
cell list
can the 'pick from list' list placed into a cell be decided by the selection
in the previous cell to it? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
cell list
One way you could do it. Assume you have two source ranges, Range1 and Range2.
Let's say F3 can have a 1 or 2 (to specify Range1 or Range2 - I would assume there is data validation to ensure only a 1 or 2 could be placed in this cell). For F4, click Data/Validation/List, and source is =INDIRECT(IF(F3=1,"Range1","Range2")) "cmac" wrote: can the 'pick from list' list placed into a cell be decided by the selection in the previous cell to it? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Drop-Down List Choice Affects Multiple Cells? | Excel Worksheet Functions | |||
| auto updating list | Excel Worksheet Functions | |||
| Custom functions calculating time arguments Help Desperate | Excel Worksheet Functions | |||
| changing value of a cell by selecting an item from a drop down list | Excel Worksheet Functions | |||
| Can a cell have a drop down list and can also be auto populated | Excel Worksheet Functions | |||
Linear Mode
