Hello,
I have on sheet(total) in each cell the formule sum of values in corresponding cells in other sheets.
Something like =SUM(test!A1;rapport!A1;halo!A1)
I want to allow a max in each cell in sheet total let us say max = "20"
Is it possible to give a warning (messagebox) when for instance
Sheet test cell A1 has value "19"
In sheet halo in cell A1 "2" is inputted, and then a messagebox pop-up "value in Sum in sheet Total is to big".
because the SUM is more than "20"
Is it possible?
Can somebody give advise?
aisietie