I have a medical charting form that requires filling in one row and then
initialing the column next to it. For instance, if the nurse takes a blood
pressure, they would log it in A1 and initial in A2. These two columns
represent one day. At this time the form must be printed, filled in and
filed. With medical records it is critical to track what was done, who did
it, and to whom. And each procedure must be initialed by the one doing it.
What I would like to do is do this digitally, then on a weekly basis print
the form, sign it and file it. Usually the same nurse is charting for the
day/shift they work but there may be a different one charting either a
different shift or day. I need a way of making them only place their
initials on the work they did. (Not that they would intentionally cheat). I
was thinking one-way would be to have a macro to require an ID to log into
the form, and then somehow an €œIF€� statement that would read the ID and
automatically enter the initials based on the ID. Or a larger macro that
would enter the initials into any selected cell or cells, again based in the
sign-in ID. This will work as long as no one shares his or her ID. Another
way might be with a vlookup, but dont know if there is a way to maintain a
certain level of security. I can do a simple IF statement (because there
would never be more then 7 people charting), but I feel this is too easy to
get around. Any ideas?

Mike Rogers