| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Updating List selection on the fly
Hello!
I have a column that contains numbers 1 to 10. I want to create a pull down menu (a list) which will show me only a certain number from that list. For example, I know I will have 10 projects in a week. We are now at the 6th project, so I want a pulldown list to show me 1 to 6. When I have 7 , then the pulldown list shows me 1 to 8. In the VALIDATION page, I can only put fixed cells... how can I put in a variable there to make my dropdown list vary? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Advanced filter and a list | New Users to Excel | |||
| Field List in Pivot Table Not updating | Excel Worksheet Functions | |||
| Allow selection of multiple values in dropdown list in excel | Excel Discussion (Misc queries) | |||
| Truncated font list in Excel's "Insert Symbol" menu selection | Excel Discussion (Misc queries) | |||
| Data Validation list selection question | Excel Worksheet Functions | |||
Linear Mode
