| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
validation in a list
I am trying to set up a growing list with one column of numerical data that
gets totaled at the bottom. Any new data must not let the total go below -2. The validation gets inserted into the new cells as they are created, but I cannot get the validation rule to change with the moving total cell as the list expands. In place of the cell address in the validation, I get REF#!. Any ideas on how to get this rule to change with the moving total cell? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Data validation list decreases as the user chooses from the list/s | Excel Discussion (Misc queries) | |||
| data validation invalid in dynamic validation list | Excel Discussion (Misc queries) | |||
| data validation invalid in dynamic validation list | Excel Worksheet Functions | |||
| Remove empty cells from named list / validation list | Excel Worksheet Functions | |||
| validation list--list depends on the selection of first list | New Users to Excel | |||
Threaded Mode
