validation in a list

B

BoatChief

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?
 
S

Sean Timmons

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?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Validation list from Named Ranges 5
list in data validation 4
Problem with Vlookup and Data Validation 3
Stopping duplication within Data validation 1
Data Validation - Complex Q 2
Amend the DV0022 - Update Validation Selections code for more lists 1
Cell validation 29
a data validation list that contains a list of named ranges - not alist from a named range 1

Top