| 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? |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
validation in a list
How are the numbers added to the sheet? are you inserting rows? are you
moving the cell with total down each time? have you tried setting up validation so it shows a formula =sum(A$1:A2)-2 so that as you go down the column, it automatically check the last value against the entire column's sum? "BoatChief" wrote: 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? |
| Reply |
| 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 | |||
Linear Mode
