Results 1 to 15 of 15
  1. #1
    Speechless
    Points: 857,363, Level: 100
    Level completed: 0%, Points required for next Level: 0
    Overall activity: 46.0%
    Achievements:
    SocialVeteranCreated Album pictures50000 Experience PointsOverdrive
    CycloneErik's Avatar
    Join Date
    Jan 2008
    Location
    Jamerica
    Posts
    55,095
    Points
    857,363
    Level
    100
    Thumbs Up
    Received: 1,312
    Given: 1,142

    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.


    Since we are an elite team now, let's go get that One Cyclone Moment.
    Make this one for the ages!




    http://rememberingdoria.wordpress.com/

  2. #2
    Addict
    Points: 119,458, Level: 100
    Level completed: 0%, Points required for next Level: 0
    Overall activity: 3.0%
    Achievements:
    SocialVeteran50000 Experience Points
    jsmith86's Avatar
    Join Date
    Dec 2006
    Location
    Tulsa
    Posts
    6,193
    Points
    119,458
    Level
    100
    Thumbs Up
    Received: 0
    Given: 0

    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.
    Warning: Posts contain 98% post-sarcastic content.
    Hoiball

  3. #3
    Speechless
    Points: 728,154, Level: 100
    Level completed: 0%, Points required for next Level: 0
    Overall activity: 41.0%
    Achievements:
    SocialVeteranCreated Album pictures50000 Experience PointsOverdrive
    Cyclonepride's Avatar
    Join Date
    Apr 2006
    Location
    A pineapple under the sea
    Posts
    47,081
    Points
    728,154
    Level
    100
    Thumbs Up
    Received: 1,083
    Given: 575

    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: 14,795, Level: 36
    Level completed: 94%, Points required for next Level: 55
    Overall activity: 2.0%
    Achievements:
    10000 Experience PointsVeteran

    Join Date
    Nov 2009
    Posts
    826
    Points
    14,795
    Level
    36
    Thumbs Up
    Received: 20
    Given: 12

    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: 857,363, Level: 100
    Level completed: 0%, Points required for next Level: 0
    Overall activity: 46.0%
    Achievements:
    SocialVeteranCreated Album pictures50000 Experience PointsOverdrive
    CycloneErik's Avatar
    Join Date
    Jan 2008
    Location
    Jamerica
    Posts
    55,095
    Points
    857,363
    Level
    100
    Thumbs Up
    Received: 1,312
    Given: 1,142

    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.


    Since we are an elite team now, let's go get that One Cyclone Moment.
    Make this one for the ages!




    http://rememberingdoria.wordpress.com/

  6. #6
    Speechless
    Points: 728,154, Level: 100
    Level completed: 0%, Points required for next Level: 0
    Overall activity: 41.0%
    Achievements:
    SocialVeteranCreated Album pictures50000 Experience PointsOverdrive
    Cyclonepride's Avatar
    Join Date
    Apr 2006
    Location
    A pineapple under the sea
    Posts
    47,081
    Points
    728,154
    Level
    100
    Thumbs Up
    Received: 1,083
    Given: 575

    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
    Recruit
    Points: 8,430, Level: 27
    Level completed: 47%, Points required for next Level: 320
    Overall activity: 0%
    Achievements:
    1 year registered5000 Experience Points

    Join Date
    Oct 2011
    Posts
    109
    Points
    8,430
    Level
    27
    Thumbs Up
    Received: 9
    Given: 0

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

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



  8. #8
    Speechless
    Points: 857,363, Level: 100
    Level completed: 0%, Points required for next Level: 0
    Overall activity: 46.0%
    Achievements:
    SocialVeteranCreated Album pictures50000 Experience PointsOverdrive
    CycloneErik's Avatar
    Join Date
    Jan 2008
    Location
    Jamerica
    Posts
    55,095
    Points
    857,363
    Level
    100
    Thumbs Up
    Received: 1,312
    Given: 1,142

    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!


    Since we are an elite team now, let's go get that One Cyclone Moment.
    Make this one for the ages!




    http://rememberingdoria.wordpress.com/

  9. #9
    Starter
    Points: 14,795, Level: 36
    Level completed: 94%, Points required for next Level: 55
    Overall activity: 2.0%
    Achievements:
    10000 Experience PointsVeteran

    Join Date
    Nov 2009
    Posts
    826
    Points
    14,795
    Level
    36
    Thumbs Up
    Received: 20
    Given: 12

    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: 857,363, Level: 100
    Level completed: 0%, Points required for next Level: 0
    Overall activity: 46.0%
    Achievements:
    SocialVeteranCreated Album pictures50000 Experience PointsOverdrive
    CycloneErik's Avatar
    Join Date
    Jan 2008
    Location
    Jamerica
    Posts
    55,095
    Points
    857,363
    Level
    100
    Thumbs Up
    Received: 1,312
    Given: 1,142

    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!


    Since we are an elite team now, let's go get that One Cyclone Moment.
    Make this one for the ages!




    http://rememberingdoria.wordpress.com/

  11. #11
    Pro
    Points: 51,959, Level: 70
    Level completed: 58%, Points required for next Level: 591
    Overall activity: 0%
    Achievements:
    Veteran50000 Experience Points
    Tank's Avatar
    Join Date
    Sep 2008
    Location
    Fort Walton Beach, FL
    Posts
    2,265
    Points
    51,959
    Level
    70
    Thumbs Up
    Received: 4
    Given: 9

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

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


    That should work....



  12. #12
    Pro
    Points: 67,830, Level: 80
    Level completed: 87%, Points required for next Level: 220
    Overall activity: 1.0%
    Achievements:
    Veteran50000 Experience Points

    Join Date
    Dec 2008
    Location
    Des Moines
    Posts
    3,238
    Points
    67,830
    Level
    80
    Thumbs Up
    Received: 49
    Given: 1

    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: 857,363, Level: 100
    Level completed: 0%, Points required for next Level: 0
    Overall activity: 46.0%
    Achievements:
    SocialVeteranCreated Album pictures50000 Experience PointsOverdrive
    CycloneErik's Avatar
    Join Date
    Jan 2008
    Location
    Jamerica
    Posts
    55,095
    Points
    857,363
    Level
    100
    Thumbs Up
    Received: 1,312
    Given: 1,142

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

    Tank excels at Contra.


    Since we are an elite team now, let's go get that One Cyclone Moment.
    Make this one for the ages!




    http://rememberingdoria.wordpress.com/

  14. #14
    Pro
    Points: 58,014, Level: 74
    Level completed: 65%, Points required for next Level: 536
    Overall activity: 9.0%
    Achievements:
    Veteran50000 Experience Points
    intrepid27's Avatar
    Join Date
    Oct 2006
    Location
    Marion, IA
    Posts
    2,554
    Points
    58,014
    Level
    74
    Thumbs Up
    Received: 84
    Given: 66

    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: 120,552, Level: 100
    Level completed: 0%, Points required for next Level: 0
    Overall activity: 17.0%
    Achievements:
    SocialVeteran50000 Experience Points
    ianoconnor's Avatar
    Join Date
    Nov 2007
    Location
    Des Moines
    Posts
    7,141
    Points
    120,552
    Level
    100
    Thumbs Up
    Received: 285
    Given: 572

    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
  •  
  • Football
  • Iowa State vs. North Dakota State
  • August 30, 2014
  • 11:00 AM