Need help copying the result of a formular only if possible

  • Thread starter Thread starter Buzz Local#30
  • Start date Start date
B

Buzz Local#30

Is there a way to copy the result of a formular only from one sheet to
another sheet and have it add to the previous number entered in that cell?
 
Copy the cell, then at the target cell, do Paste Special (right-click for it) - Values and
Add.
 
Select the cell with the formula in, click <copy>, click on the tab
for the destination sheet, select the cell that you want to amend,
click on Edit | Paste Special | Values (check) | Add (check) | OK then
<Esc>.

Hope this helps.

Pete
 
Back
Top