Results 1 to 8 of 8
  1. #1
    New Lounger
    Join Date
    Dec 2014
    Posts
    3
    Thanks
    1
    Thanked 0 Times in 0 Posts

    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?
    Last edited by Karen Gudnason; 2014-12-30 at 20:15.

  2. #2
    Super Moderator RetiredGeek's Avatar
    Join Date
    Mar 2004
    Location
    Manning, South Carolina
    Posts
    9,434
    Thanks
    372
    Thanked 1,457 Times in 1,326 Posts
    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
    Last edited by RetiredGeek; 2014-12-31 at 05:18.
    May the Forces of good computing be with you!

    RG

    PowerShell & VBA Rule!

    My Systems: Desktop Specs
    Laptop Specs

  3. #3
    Gold Lounger Maudibe's Avatar
    Join Date
    Aug 2010
    Location
    Pa, USA
    Posts
    2,633
    Thanks
    115
    Thanked 648 Times in 591 Posts
    A pictorial presentation of RG's solution:

    img1.png

  4. #4
    WS Lounge VIP
    Join Date
    Dec 2009
    Location
    Earth
    Posts
    8,179
    Thanks
    47
    Thanked 983 Times in 913 Posts
    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. #5
    New Lounger
    Join Date
    Dec 2014
    Posts
    3
    Thanks
    1
    Thanked 0 Times in 0 Posts
    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. #6
    New Lounger
    Join Date
    Dec 2014
    Posts
    3
    Thanks
    1
    Thanked 0 Times in 0 Posts
    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. #7
    WS Lounge VIP
    Join Date
    Dec 2009
    Location
    Earth
    Posts
    8,179
    Thanks
    47
    Thanked 983 Times in 913 Posts
    Quote Originally Posted by Karen Gudnason View Post
    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. #8
    5 Star Lounger
    Join Date
    Jan 2004
    Location
    Praha
    Posts
    988
    Thanks
    56
    Thanked 105 Times in 90 Posts
    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
  •