B
Bill Coleman
Could someone point me in right direction which would allow me to take the
sports schedule referenced below:
www.hotsoccer.net
select game schedule, then "in Excel format"
and extrapolate out each individual team's separate schedule, similar to
below:
TEAM 101
Sept. 16 Field 3 101 vs 103
Sept. 23 Field 1 104 vs 101
Oct. 3 Field 5 101 vs 107
Oct. 9 Field 22 102 vs 101
TEAM 102
Sept. 16 Field 6 102 vs 118
Sept. 23 Field 15 109 vs 102
Oct. 3 Field 2 105 vs 102
Oct. 9 Field 20 102 vs 101
The schedule template is in the exact same format year after year.
Would I use a lookup table, macro, etc.?
Thanks.
sports schedule referenced below:
www.hotsoccer.net
select game schedule, then "in Excel format"
and extrapolate out each individual team's separate schedule, similar to
below:
TEAM 101
Sept. 16 Field 3 101 vs 103
Sept. 23 Field 1 104 vs 101
Oct. 3 Field 5 101 vs 107
Oct. 9 Field 22 102 vs 101
TEAM 102
Sept. 16 Field 6 102 vs 118
Sept. 23 Field 15 109 vs 102
Oct. 3 Field 2 105 vs 102
Oct. 9 Field 20 102 vs 101
The schedule template is in the exact same format year after year.
Would I use a lookup table, macro, etc.?
Thanks.