# Thread: Help! How do I transfer the Total (J2-J23) in J23 worksheet A to J2 in worksheet B?

1. ## Help! How do I transfer the Total (J2-J23) in J23 worksheet A to J2 in worksheet B?

When I copy J23 worksheet A and paste to J2 on worksheet B it gives me a 0.00. How do I define worksheet A in a formula in worksheet B cell J2? ie. =worksheetAJ23. HOW IS WORKSHEET A REPRESENTED? WSA?

Let me put it another way. How do I carry over the total from cell J23 in one work worksheet to cell J2 in the next worksheet?

2. Karen,

Welcome to the Lounge as a new Poster!

If your worksheet is really named A (e.g. what shows on the Tab) then on Worksheet B you would use A!J23 or more fully: =Sum(A!J2:J22)

HTH

3. A pictorial presentation of RG's solution:

img1.png

4. With the cursor in the required cell, press =
Navigate to the source worksheet and cell.
Press Enter to accept the result.

cheers, Paul

5. ## The Following User Says Thank You to Paul T For This Useful Post:

Karen Gudnason (2014-12-31)

6. The Tab is actually called January 15. So do I type in
=Sum(January 15!J2:J23)?

That didn't work I got #name? in my cell...

But Thank you! Got any other ideas?

7. Thank you Paul T! I knew it was something easy, I just couldn't remember. I haven't done this for a while

Thank you too RG! I'm sure if I labeled my tabs differently that would work to. It seems I rarely do anythings the easy way...

Karen

8. Originally Posted by Karen Gudnason
The Tab is actually called January 15. So do I type in
=Sum(January 15!J2:J23)?
You need quotes around the name as it has spaces.

cheers, Paul

9. Or . . .
Click on the source cell and click on Edit . . . Copy (or CTRL C).
Click on the destination cell and click on Edit . . . Paste Special . . . Paste Link (Do not hit Return after clicking on Paste Link) (or ALT E S L)

#### Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts
•