N
Newbie
I am in charge of keeping track of how many medical residents are on a
rotation at a time and making sure that we do not go over the alloted amount
of spots on this rotation during a certain time period (usually 4 week blocks
x 13 blocks per year). Currently I use excel and each residency program has
their own worksheet in this excel file in which they have access to on a
shared drive. The program is responsible for inserting the resident's name
and their block schedule for the year on these worksheets. I am responsible
for making sure that the formulas are correct (I use countif because the
rotations are in text format). The problem I run into is that there are a
lot of errors made by these programs who enter in the info for their
worksheets, which in turn causes the counts for the rotations to be incorrect.
My question is - is there an easier way to keep track of the rotation count
sheet that also allows the programs to insert and edit their info making sure
that the info is correct (such as a dropdown menu) that all would have to
use. I can provide an example if this would help. This does not have to be
in excel, but I would need directions/or help on setting it up in another
program such as infopath, etc.
rotation at a time and making sure that we do not go over the alloted amount
of spots on this rotation during a certain time period (usually 4 week blocks
x 13 blocks per year). Currently I use excel and each residency program has
their own worksheet in this excel file in which they have access to on a
shared drive. The program is responsible for inserting the resident's name
and their block schedule for the year on these worksheets. I am responsible
for making sure that the formulas are correct (I use countif because the
rotations are in text format). The problem I run into is that there are a
lot of errors made by these programs who enter in the info for their
worksheets, which in turn causes the counts for the rotations to be incorrect.
My question is - is there an easier way to keep track of the rotation count
sheet that also allows the programs to insert and edit their info making sure
that the info is correct (such as a dropdown menu) that all would have to
use. I can provide an example if this would help. This does not have to be
in excel, but I would need directions/or help on setting it up in another
program such as infopath, etc.