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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Back
Top