Results 1 to 15 of 15
  1. #1
    Speechless
    Points: 945,229, Level: 100
    Level completed: 0%, Points required for next Level: 0
    Overall activity: 43.0%
    Achievements:
    SocialVeteranCreated Album pictures50000 Experience PointsOverdrive
    CycloneErik's Avatar
    Join Date
    Jan 2008
    Location
    Jamerica
    Posts
    64,811
    Points
    945,229
    Level
    100
    Thumbs Up
    Received: 8,175
    Given: 7,012

    Excel--Can you automatically....?

    Is it possible to set up something in Excel to automatically move data between different tabs on an Excel spreadsheet?

    Thanks. My search in Excel is getting strange results.


    Kansas Must Be Destroyed

    Sic Semper Jayhawks




    http://rememberingdoria.wordpress.com/

  2. #2
    Addict
    Points: 146,762, Level: 100
    Level completed: 0%, Points required for next Level: 0
    Overall activity: 23.0%
    Achievements:
    SocialVeteran50000 Experience Points
    jsmith86's Avatar
    Join Date
    Dec 2006
    Location
    Tulsa
    Posts
    7,120
    Points
    146,762
    Level
    100
    Thumbs Up
    Received: 436
    Given: 1,740

    Re: Excel--Can you automatically....?

    You might be able to make something in VBA to do it for you.


    You can't die. That would upset the equilibrium in the Cave.
    Prohman Empire.




  3. #3
    Speechless
    Points: 827,683, Level: 100
    Level completed: 0%, Points required for next Level: 0
    Overall activity: 99.9%
    Achievements:
    SocialVeteranCreated Album pictures50000 Experience PointsOverdrive
    Cyclonepride's Avatar
    Join Date
    Apr 2006
    Location
    A pineapple under the sea
    Posts
    58,286
    Points
    827,683
    Level
    100
    Thumbs Up
    Received: 8,715
    Given: 3,891

    Re: Excel--Can you automatically....?

    Pretty sure you can. I'd think you'd just put =, then click the cell from the other sheet.



  4. #4
    Starter
    Points: 16,859, Level: 39
    Level completed: 52%, Points required for next Level: 391
    Overall activity: 1.0%
    Achievements:
    10000 Experience PointsVeteran

    Join Date
    Nov 2009
    Posts
    951
    Points
    16,859
    Level
    39
    Thumbs Up
    Received: 77
    Given: 33

    Re: Excel--Can you automatically....?

    or record a macro....

    Be a little more specific, are you trying to move whole sheets or only a couple values.



  5. #5
    Speechless
    Points: 945,229, Level: 100
    Level completed: 0%, Points required for next Level: 0
    Overall activity: 43.0%
    Achievements:
    SocialVeteranCreated Album pictures50000 Experience PointsOverdrive
    CycloneErik's Avatar
    Join Date
    Jan 2008
    Location
    Jamerica
    Posts
    64,811
    Points
    945,229
    Level
    100
    Thumbs Up
    Received: 8,175
    Given: 7,012

    Re: Excel--Can you automatically....?

    Quote Originally Posted by dabears32 View Post
    or record a macro....

    Be a little more specific, are you trying to move whole sheets or only a couple values.
    Just one column, really.

    Just part of keeping track of scores. I made separate tabs for each separate part of their score. What I'd like to do is to have the tabulated score for each student import over to the first tab, which keeps track of the overall score.


    Kansas Must Be Destroyed

    Sic Semper Jayhawks




    http://rememberingdoria.wordpress.com/

  6. #6
    Speechless
    Points: 827,683, Level: 100
    Level completed: 0%, Points required for next Level: 0
    Overall activity: 99.9%
    Achievements:
    SocialVeteranCreated Album pictures50000 Experience PointsOverdrive
    Cyclonepride's Avatar
    Join Date
    Apr 2006
    Location
    A pineapple under the sea
    Posts
    58,286
    Points
    827,683
    Level
    100
    Thumbs Up
    Received: 8,715
    Given: 3,891

    Re: Excel--Can you automatically....?

    On our excel estimating program, I set up a separate page to input customer names and addresses, and then did the =cell to automatically transfer that to all of the worksheets/pay sheets in the other tabs.



  7. #7
    Walk On
    Points: 9,732, Level: 29
    Level completed: 64%, Points required for next Level: 218
    Overall activity: 2.0%
    Achievements:
    5000 Experience PointsVeteran

    Join Date
    Oct 2011
    Posts
    133
    Points
    9,732
    Level
    29
    Thumbs Up
    Received: 23
    Given: 0

    Re: Excel--Can you automatically....?

    =TabName!A1 should give you what you're looking for.



  8. #8
    Speechless
    Points: 945,229, Level: 100
    Level completed: 0%, Points required for next Level: 0
    Overall activity: 43.0%
    Achievements:
    SocialVeteranCreated Album pictures50000 Experience PointsOverdrive
    CycloneErik's Avatar
    Join Date
    Jan 2008
    Location
    Jamerica
    Posts
    64,811
    Points
    945,229
    Level
    100
    Thumbs Up
    Received: 8,175
    Given: 7,012

    Re: Excel--Can you automatically....?

    Quote Originally Posted by Pat View Post
    =TabName!A1 should give you what you're looking for.
    Yes, that's working!


    Kansas Must Be Destroyed

    Sic Semper Jayhawks




    http://rememberingdoria.wordpress.com/

  9. #9
    Starter
    Points: 16,859, Level: 39
    Level completed: 52%, Points required for next Level: 391
    Overall activity: 1.0%
    Achievements:
    10000 Experience PointsVeteran

    Join Date
    Nov 2009
    Posts
    951
    Points
    16,859
    Level
    39
    Thumbs Up
    Received: 77
    Given: 33

    Re: Excel--Can you automatically....?

    Quote Originally Posted by CycloneErik View Post
    Just one column, really.

    Just part of keeping track of scores. I made separate tabs for each separate part of their score. What I'd like to do is to have the tabulated score for each student import over to the first tab, which keeps track of the overall score.
    If I understand you correctly, should be able to do it like it was on the same sheet. This can be done by clicking on the tab and selecting the cell you want or by doing the exclamation point method mentioned above. The do the copy formula/drag down thing to avoid the repetitive nature of it. I hope this helps


    Last edited by dabears32; 10-20-2011 at 11:50 PM. Reason: nm apparently you got it now

  10. #10
    Speechless
    Points: 945,229, Level: 100
    Level completed: 0%, Points required for next Level: 0
    Overall activity: 43.0%
    Achievements:
    SocialVeteranCreated Album pictures50000 Experience PointsOverdrive
    CycloneErik's Avatar
    Join Date
    Jan 2008
    Location
    Jamerica
    Posts
    64,811
    Points
    945,229
    Level
    100
    Thumbs Up
    Received: 8,175
    Given: 7,012

    Re: Excel--Can you automatically....?

    Quote Originally Posted by dabears32 View Post
    If I understand you correctly, should be able to do it like it was on the same sheet. This can be done by clicking on the tab and selecting the cell you want or by doing the exclamation point method mentioned above. The do the copy formula/drag down thing to avoid the repetitive nature of it. I hope this helps
    I'm living on the copy/drag formula thing. That would just be a mind-numbing death to do this thing without it.

    I am living my spreadsheet dream tonight!


    Kansas Must Be Destroyed

    Sic Semper Jayhawks




    http://rememberingdoria.wordpress.com/

  11. #11
    Pro
    Points: 53,150, Level: 71
    Level completed: 40%, Points required for next Level: 900
    Overall activity: 0%
    Achievements:
    Veteran50000 Experience Points
    Tank's Avatar
    Join Date
    Sep 2008
    Location
    Niceville, FL
    Posts
    2,293
    Points
    53,150
    Level
    71
    Thumbs Up
    Received: 15
    Given: 19

    Re: Excel--Can you automatically....?

    Up, Up, Down, Down, Left, Right, Left, Right, B, A, Start


    That should work....



  12. #12
    Hall-Of-Famer
    Points: 73,133, Level: 83
    Level completed: 99%, Points required for next Level: 17
    Overall activity: 14.0%
    Achievements:
    Veteran50000 Experience Points

    Join Date
    Dec 2008
    Location
    Des Moines
    Posts
    4,599
    Points
    73,133
    Level
    83
    Thumbs Up
    Received: 799
    Given: 18

    Re: Excel--Can you automatically....?

    Quote Originally Posted by Tank View Post
    Up, Up, Down, Down, Left, Right, Left, Right, B, A, Start


    That should work....
    Bonus lives in Contra?



  13. #13
    Speechless
    Points: 945,229, Level: 100
    Level completed: 0%, Points required for next Level: 0
    Overall activity: 43.0%
    Achievements:
    SocialVeteranCreated Album pictures50000 Experience PointsOverdrive
    CycloneErik's Avatar
    Join Date
    Jan 2008
    Location
    Jamerica
    Posts
    64,811
    Points
    945,229
    Level
    100
    Thumbs Up
    Received: 8,175
    Given: 7,012

    Re: Excel--Can you automatically....?

    Tank excels at Contra.


    Kansas Must Be Destroyed

    Sic Semper Jayhawks




    http://rememberingdoria.wordpress.com/

  14. #14
    Pro
    Points: 73,807, Level: 84
    Level completed: 39%, Points required for next Level: 1,043
    Overall activity: 4.0%
    Achievements:
    Veteran50000 Experience Points
    intrepid27's Avatar
    Join Date
    Oct 2006
    Location
    Marion, IA
    Posts
    2,996
    Points
    73,807
    Level
    84
    Thumbs Up
    Received: 409
    Given: 501

    Re: Excel--Can you automatically....?

    Yes, just treat the cells in the other tab as if they were on the same page.



  15. #15
    Addict
    Points: 134,952, Level: 100
    Level completed: 0%, Points required for next Level: 0
    Overall activity: 6.0%
    Achievements:
    SocialVeteran50000 Experience Points
    ianoconnor's Avatar
    Join Date
    Nov 2007
    Location
    Des Moines
    Posts
    8,228
    Points
    134,952
    Level
    100
    Thumbs Up
    Received: 1,179
    Given: 2,610

    Re: Excel--Can you automatically....?

    Excel can probably cook you dinner if you know the right formula...



Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
  • TV: ESPN
  • HOOPS: Iowa State vs. Texas
  • February 13, 2016
  • 07:30 PM