Resetting Cell Values

  • Thread starter Thread starter dwalsh77
  • Start date Start date
D

dwalsh77

I currently have 2 columns that contain a group of number in each. A
the bottom of each column, I have a formula that gets the sum of th
numbers in each column and subtracts that total from a pre-determine
number. Once that pre-determined number reaches 0, I want all of th
numbers in the 2 columns to reset back to their original settin
(BLANK).

Is this possible using an IF Statement?

Thanks for any help
 
I take it that this "predetermined" number is in some cell? How does it
change? Manually? By formula? By code?
You can't do what you want with an IF statement in a cell. You will need a
macro that "sees" this "predetermined" number and takes action when it
reaches zero. HTH Otto
 
Back
Top