Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Drop down list
Hi folks,
I have 3 drop down lists on sheet 1 of a spreadsheet, all of which relate to other sheets in the workbook. Can I set the drop down lists up to allow for future expansion of the other worksheets. In Validate Data, i have tried increasing the range of the source but this leaves a number of blanks at the end of the drop down box. Although this solves the problem I was hoping for some advice on a neater way to achieve my aims. Thanks for the help. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Drop down list
Maybe you could use a dynamic name:
See Debra Dalgeish's site for some nice tips: http://contextures.com/xlNames01.html#Dynamic SteveinHouston wrote: Hi folks, I have 3 drop down lists on sheet 1 of a spreadsheet, all of which relate to other sheets in the workbook. Can I set the drop down lists up to allow for future expansion of the other worksheets. In Validate Data, i have tried increasing the range of the source but this leaves a number of blanks at the end of the drop down box. Although this solves the problem I was hoping for some advice on a neater way to achieve my aims. Thanks for the help. -- Dave Peterson |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Drop down list
Thanks for that, its done the trick.
"Dave Peterson" wrote: Maybe you could use a dynamic name: See Debra Dalgeish's site for some nice tips: http://contextures.com/xlNames01.html#Dynamic SteveinHouston wrote: Hi folks, I have 3 drop down lists on sheet 1 of a spreadsheet, all of which relate to other sheets in the workbook. Can I set the drop down lists up to allow for future expansion of the other worksheets. In Validate Data, i have tried increasing the range of the source but this leaves a number of blanks at the end of the drop down box. Although this solves the problem I was hoping for some advice on a neater way to achieve my aims. Thanks for the help. -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I make other cells dependent on my drop down list? | Excel Discussion (Misc queries) | |||
changing value of a cell by selecting an item from a drop down list | Excel Worksheet Functions | |||
Pull unique names for drop down list | Excel Discussion (Misc queries) | |||
drop down list multiple columns | Excel Discussion (Misc queries) | |||
Drop List Referencing | Excel Worksheet Functions |