G
Guest
Hi! I'm not sure if this is possible. I want to create a "master" schedule
for our hockey association which has all the scheduled games for every
division on one main schedule. One of the names of the columns on the master
schedule would be for "Division". I wanted to have a separate worksheet for
each division (IP1, IP2, Atom, Peewee, Bantam, Midget) that would
automatically be populate from the information on the master schedule - ie
all the ice times and other info for IP1 from the master schedule would show
on the sheet for IP1, all the ice times/info for IP2 would should on the IP2
worksheet, etc etc.
First, is this possible? If so, what functions would you use? Or would it
require programming of some kind? Too difficult for someone with mediocre
Excel skills?
for our hockey association which has all the scheduled games for every
division on one main schedule. One of the names of the columns on the master
schedule would be for "Division". I wanted to have a separate worksheet for
each division (IP1, IP2, Atom, Peewee, Bantam, Midget) that would
automatically be populate from the information on the master schedule - ie
all the ice times and other info for IP1 from the master schedule would show
on the sheet for IP1, all the ice times/info for IP2 would should on the IP2
worksheet, etc etc.
First, is this possible? If so, what functions would you use? Or would it
require programming of some kind? Too difficult for someone with mediocre
Excel skills?