First a thanks in advanced.
I am doing a formula in column b that is as followed =SUM(B3+E3-H3) this will give me the answer in the B4 cell. columns E and H have data that can/will change daily. B3 is a starting number lets say 40. so i have 40+8(e3)-3(h3)=45 which will display in B4. This repeats the whole column down so the next cell B5 will display =sum(b4+e4-h4) etc.
Is there a way to hide the numbers after the last one used in B5?
I am doing a formula in column b that is as followed =SUM(B3+E3-H3) this will give me the answer in the B4 cell. columns E and H have data that can/will change daily. B3 is a starting number lets say 40. so i have 40+8(e3)-3(h3)=45 which will display in B4. This repeats the whole column down so the next cell B5 will display =sum(b4+e4-h4) etc.
Is there a way to hide the numbers after the last one used in B5?