Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 12-16-2015, 02:01 PM
tesoke tesoke is offline save sum of 2 number after deleting them Windows 8 save sum of 2 number after deleting them Office 2013
Advanced Beginner
save sum of 2 number after deleting them
 
Join Date: Apr 2015
Posts: 56
tesoke is on a distinguished road
Default 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.
Attached Images
File Type: png 12.png (15.5 KB, 12 views)
Reply With Quote
  #2  
Old 12-17-2015, 04:19 AM
SumitBansal SumitBansal is offline save sum of 2 number after deleting them Windows 10 save sum of 2 number after deleting them Office 2013
Novice
 
Join Date: Dec 2015
Location: India
Posts: 6
SumitBansal is on a distinguished road
Default

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.
Reply With Quote
  #3  
Old 12-17-2015, 12:33 PM
Pecoflyer's Avatar
Pecoflyer Pecoflyer is offline save sum of 2 number after deleting them Windows 7 64bit save sum of 2 number after deleting them Office 2010 64bit
Expert
 
Join Date: Nov 2011
Location: Brussels Belgium
Posts: 2,505
Pecoflyer is a splendid one to beholdPecoflyer is a splendid one to beholdPecoflyer is a splendid one to beholdPecoflyer is a splendid one to beholdPecoflyer is a splendid one to beholdPecoflyer is a splendid one to beholdPecoflyer is a splendid one to behold
Default

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
Reply With Quote
  #4  
Old 12-17-2015, 02:14 PM
tesoke tesoke is offline save sum of 2 number after deleting them Windows 8 save sum of 2 number after deleting them Office 2013
Advanced Beginner
save sum of 2 number after deleting them
 
Join Date: Apr 2015
Posts: 56
tesoke is on a distinguished road
Default

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

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
save sum of 2 number after deleting them 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
save sum of 2 number after deleting them Deleting a script in an equation without deleting the whole term allankey Word 1 02-15-2014 07:09 AM
save sum of 2 number after deleting them 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

Other Forums: Access Forums

All times are GMT -7. The time now is 05:21 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2021, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2021 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft