Results 1 to 15 of 15
  1. #1
    Speechless
    Points: 963,917, Level: 100
    Level completed: 0%, Points required for next Level: 0
    Overall activity: 58.0%
    Achievements:
    SocialVeteranCreated Album pictures50000 Experience PointsOverdrive
    CycloneErik's Avatar
    Join Date
    Jan 2008
    Location
    Jamerica
    Posts
    66,855
    Points
    963,917
    Level
    100
    Thumbs Up
    Received: 9,434
    Given: 8,329

    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: 155,533, Level: 100
    Level completed: 0%, Points required for next Level: 0
    Overall activity: 13.0%
    Achievements:
    SocialVeteran50000 Experience Points
    jsmith86's Avatar
    Join Date
    Dec 2006
    Location
    Cedar Rapids
    Posts
    7,574
    Points
    155,533
    Level
    100
    Thumbs Up
    Received: 768
    Given: 3,564

    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
    UVA est, ut destruatur
    Points: 858,633, Level: 100
    Level completed: 0%, Points required for next Level: 0
    Overall activity: 64.0%
    Achievements:
    SocialVeteranCreated Album pictures50000 Experience PointsOverdrive
    Cyclonepride's Avatar
    Join Date
    Apr 2006
    Location
    A pineapple under the sea
    Posts
    60,687
    Points
    858,633
    Level
    100
    Thumbs Up
    Received: 10,951
    Given: 4,859

    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: 17,340, Level: 40
    Level completed: 12%, Points required for next Level: 710
    Overall activity: 0%
    Achievements:
    10000 Experience PointsVeteran

    Join Date
    Nov 2009
    Posts
    987
    Points
    17,340
    Level
    40
    Thumbs Up
    Received: 133
    Given: 43

    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: 963,917, Level: 100
    Level completed: 0%, Points required for next Level: 0
    Overall activity: 58.0%
    Achievements:
    SocialVeteranCreated Album pictures50000 Experience PointsOverdrive
    CycloneErik's Avatar
    Join Date
    Jan 2008
    Location
    Jamerica
    Posts
    66,855
    Points
    963,917
    Level
    100
    Thumbs Up
    Received: 9,434
    Given: 8,329

    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
    UVA est, ut destruatur
    Points: 858,633, Level: 100
    Level completed: 0%, Points required for next Level: 0
    Overall activity: 64.0%
    Achievements:
    SocialVeteranCreated Album pictures50000 Experience PointsOverdrive
    Cyclonepride's Avatar
    Join Date
    Apr 2006
    Location
    A pineapple under the sea
    Posts
    60,687
    Points
    858,633
    Level
    100
    Thumbs Up
    Received: 10,951
    Given: 4,859

    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: 10,053, Level: 30
    Level completed: 18%, Points required for next Level: 497
    Overall activity: 2.0%
    Achievements:
    Veteran10000 Experience Points

    Join Date
    Oct 2011
    Posts
    162
    Points
    10,053
    Level
    30
    Thumbs Up
    Received: 37
    Given: 0

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

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



  8. #8
    Speechless
    Points: 963,917, Level: 100
    Level completed: 0%, Points required for next Level: 0
    Overall activity: 58.0%
    Achievements:
    SocialVeteranCreated Album pictures50000 Experience PointsOverdrive
    CycloneErik's Avatar
    Join Date
    Jan 2008
    Location
    Jamerica
    Posts
    66,855
    Points
    963,917
    Level
    100
    Thumbs Up
    Received: 9,434
    Given: 8,329

    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: 17,340, Level: 40
    Level completed: 12%, Points required for next Level: 710
    Overall activity: 0%
    Achievements:
    10000 Experience PointsVeteran

    Join Date
    Nov 2009
    Posts
    987
    Points
    17,340
    Level
    40
    Thumbs Up
    Received: 133
    Given: 43

    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 10:50 PM. Reason: nm apparently you got it now

  10. #10
    Speechless
    Points: 963,917, Level: 100
    Level completed: 0%, Points required for next Level: 0
    Overall activity: 58.0%
    Achievements:
    SocialVeteranCreated Album pictures50000 Experience PointsOverdrive
    CycloneErik's Avatar
    Join Date
    Jan 2008
    Location
    Jamerica
    Posts
    66,855
    Points
    963,917
    Level
    100
    Thumbs Up
    Received: 9,434
    Given: 8,329

    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: 54,563, Level: 72
    Level completed: 35%, Points required for next Level: 987
    Overall activity: 0%
    Achievements:
    Veteran50000 Experience Points
    Tank's Avatar
    Join Date
    Sep 2008
    Location
    Niceville, FL
    Posts
    2,293
    Points
    54,563
    Level
    72
    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: 74,183, Level: 84
    Level completed: 61%, Points required for next Level: 667
    Overall activity: 5.0%
    Achievements:
    Veteran50000 Experience Points

    Join Date
    Dec 2008
    Location
    Des Moines
    Posts
    4,751
    Points
    74,183
    Level
    84
    Thumbs Up
    Received: 911
    Given: 20

    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: 963,917, Level: 100
    Level completed: 0%, Points required for next Level: 0
    Overall activity: 58.0%
    Achievements:
    SocialVeteranCreated Album pictures50000 Experience PointsOverdrive
    CycloneErik's Avatar
    Join Date
    Jan 2008
    Location
    Jamerica
    Posts
    66,855
    Points
    963,917
    Level
    100
    Thumbs Up
    Received: 9,434
    Given: 8,329

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

    Tank excels at Contra.


    Kansas Must Be Destroyed

    Sic Semper Jayhawks




    http://rememberingdoria.wordpress.com/

  14. #14
    Pro
    Points: 75,328, Level: 85
    Level completed: 29%, Points required for next Level: 1,222
    Overall activity: 8.0%
    Achievements:
    Veteran50000 Experience Points
    intrepid27's Avatar
    Join Date
    Oct 2006
    Location
    Marion, IA
    Posts
    3,067
    Points
    75,328
    Level
    85
    Thumbs Up
    Received: 459
    Given: 600

    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: 136,266, Level: 100
    Level completed: 0%, Points required for next Level: 0
    Overall activity: 5.0%
    Achievements:
    SocialVeteran50000 Experience Points
    ianoconnor's Avatar
    Join Date
    Nov 2007
    Location
    Urbandale
    Posts
    8,334
    Points
    136,266
    Level
    100
    Thumbs Up
    Received: 1,285
    Given: 2,850

    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: TBA
  • Football Season Opener vs. UNI
  • September 3, 2016
  • 07:00 PM