dahowarduk
New member
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?
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?