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. Which I have to go in and search for the incorrect entry (it may
be a space or just spelled wrong, etc.)
My question is - is there an easier way to keep track of the Master rotation
count
sheet that also allows the programs to insert 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 visual basics, infopath, etc. I am somewhat confused as to
where to start on this project.
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. Which I have to go in and search for the incorrect entry (it may
be a space or just spelled wrong, etc.)
My question is - is there an easier way to keep track of the Master rotation
count
sheet that also allows the programs to insert 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 visual basics, infopath, etc. I am somewhat confused as to
where to start on this project.