(Msg. 1) Posted: Thu Oct 16, 2008 2:39 pm
Post subject: how do I make a sports schedule Archived from groups: microsoft>public>excel>setup (more info?)
i AM TRYING TO MAKE A SPORTS SCHEDULE THAT EACH TEAM PLAYS EACH OTHER ONCE
(Msg. 2) Posted: Fri Oct 17, 2008 2:12 am
Post subject: RE: how do I make a sports schedule [Login to view extended thread Info.] Archived from groups: per prev. post (more info?)
You gave not very much details, but if you have a list of teams in A2:A? then
this macro creates a combination of opponents for each team, then you can put
dates of matches in cells B1, C1, etc.
Sub sched()
Dim teams As Range, t As Range, e As Range
Noofteams = Range("A" & Rows.Count).End(xlUp).Row
Set teams = Range("A2:A" & Noofteams)
For Each t In teams
nexte = 0
For Each e In teams
If t <> e Then
nexte = nexte + 1
Cells(t.Row, nexte + 1).Value = e.Value
End If
Next e
Next t
End Sub
Regards,
Stefi
„SHOETAC” ezt írta:
> i AM TRYING TO MAKE A SPORTS SCHEDULE THAT EACH TEAM PLAYS EACH OTHER ONCE
(Msg. 3) Posted: Fri Oct 17, 2008 8:26 pm
Post subject: RE: how do I make a sports schedule [Login to view extended thread Info.] Archived from groups: per prev. post (more info?)
Hi,
Try Googling "sports schedule in Excel" or "creating a sports schedule in
Excel"
--
Thanks,
Shane Devenshire
"SHOETAC" wrote:
> i AM TRYING TO MAKE A SPORTS SCHEDULE THAT EACH TEAM PLAYS EACH OTHER ONCE
All times are: Eastern Time (US & Canada) (change)
Page 1 of 1
You can post new topics in this forum You can reply to topics in this forum You cannot edit your posts in this forum You cannot delete your posts in this forum You cannot vote in polls in this forum