Hi, I need help for a simple problem about Excel. Please help like always. Bless you.



I had a simple Excel file, like the attached picture, which have 2 numbers. Cell B4 calculates sum of them. I want to save the value of B4 in B6 and then delete B2, B3 and B4. So, I copy B4 in B6; but after deleting B2, B3 and B4, the value of B6 is deleting too. Is there another method, except copy/past or writing the value of B4 in B6 by hand, to save the value of B6 even deleting the values of B2, B3 and B4?

Thanks for any help.

Attached Images

12.png (15.5 KB, 18 views)

Since your value in B6 is dependent on B4, it will show 0 as soon as you delete it. You can copy and paste special as values. But that needs to be done every time you change the values.

Another way is to use a VBA code.

Long explanation but easy to do
Select the cell you want to keep the value of
Place cursor against the upper border of the selected cell. It turns ot another symbol.( "cross with arrows"?)
While holding down the right button of your mouse move the cell around and drop it where you want ( same place is ok)
A menu appears
Select "copy here as values only". Done

The same can be done with ranges

__________________
Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post

Thank you so much. Like always, my problem solved. Bless you.