Hello,
I'm trying to create a tournamnet schedule with a different value in amount of lanes.
I would like to create a Private Sub for a worksheet which creates a number sequence based on a cell value from another worksheet.
If value in cell D2 on Sheet "Teams" is 4 , this will create a number sequence on sheet "12" which will be 1,2,3,4,1,2,3,4,1,2.... in cells H1-M1 and continues in H4-M4 , H7-M7 and keeps on running to H28-M28
If the value is 3 the sequence shall be 1,2,3,1,2,3,1,2.... in the same cells as above.
I hope the picture can shed some light over my problem.
Bookmarks