#1
|
|||
|
|||
save sum of 2 number after deleting them
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. |
#2
|
|||
|
|||
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. |
#3
|
||||
|
||||
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 |
#4
|
|||
|
|||
Thank you so much. Like always, my problem solved. Bless you.
|
Thread Tools | |
Display Modes | |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
How to create a table with a number of line depending a number entered by user | Cellendhyll | Word Tables | 3 | 07-10-2014 05:49 AM |
Deleting a script in an equation without deleting the whole term | allankey | Word | 1 | 02-15-2014 07:09 AM |
When I try to save an existing word doc, save as pops up and will not save... | samanthab | Word | 3 | 01-19-2013 06:27 AM |
excel 2010 not deleting tmp files on save/close | willbaker13 | Excel | 0 | 04-26-2012 05:08 PM |
Files deleting on save | email_Signup123 | Excel | 0 | 04-29-2007 04:42 AM |