Results 1 to 2 of 2

Thread: Sort Macro

  1. #1
    Seeker dahowarduk's Avatar
    Join Date
    Jul 2012
    Posts
    16
    Articles
    0
    Excel Version
    14.0.7237.5000

    Sort Macro



    Register for a FREE account, and/
    or Log in to avoid these ads!

    I run a fun football (soccer) competition.
    I have a spreadsheet that contains several worksheets, that are named ROUND 1, ROUND 2 etc up to ROUND 10.
    If the current round is say ROUND 6, I want to copy the contents of the worksheet ROUND 6 into another worksheet entitled CURRENT ROUND, where some special sort procedures are performed using a couple of sort macros.
    If (say) the current round is ROUND 4, then I would then want the contents of ROUND 4 to appear in CURRENT ROUND.
    I don't know how to do that. (other than cut & paste)

    Alternatively, could I somehow get the special sort macros that are used in CURRENT ROUND, to operate on say ROUND 2 or any other chosen Round?

  2. #2
    Acolyte bobjglover@gmail.com's Avatar
    Join Date
    Aug 2015
    Posts
    52
    Articles
    0
    Excel Version
    1901
    Greetings,

    Attaching an example is always helpful. In short to both questions, you can Record a macro just like the "sort" macro you use to copy the next round into current. Typically you should be able to use the Sort macro on a different worksheet as long as the parameters are set up the same.

    Developer Menu>Design Mode> Record Macro> (name it what you would like, no space in name)> and then every action you make next will be recorded until you go back to the menu hand hit Stop. Very simple, you can edit, also. Practice on a blank worksheet until you feel confident to bring to the live data.

    Hope this helps!
    Last edited by bobjglover@gmail.com; 2020-01-21 at 09:23 PM.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •