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 19:15.

  2. #2
    Super Moderator RetiredGeek's Avatar
    Join Date
    Mar 2004
    Location
    Manning, South Carolina
    Posts
    9,731
    Thanks
    395
    Thanked 1,533 Times in 1,390 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 04: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,754
    Thanks
    129
    Thanked 693 Times in 629 Posts
    A pictorial presentation of RG's solution:

    img1.png

  4. #4
    WS Lounge VIP
    Join Date
    Dec 2009
    Location
    Earth
    Posts
    8,609
    Thanks
    56
    Thanked 1,055 Times in 983 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,609
    Thanks
    56
    Thanked 1,055 Times in 983 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
    1,051
    Thanks
    69
    Thanked 118 Times in 103 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
  •