At our hospital, we keep track of our patients using an excell worksheet (The "list") that we update frequently. The "list" contains information about each patient including their room number, name, history, and so on.
Everyday we write patient notes on each of these people, and we end up writing exactly what is on our list by hand.
I am looking for someone to write an excell based program to take information from each row(=patient) of our list, and create a new worksheet for each patient, using one of 2 templates based on the room number, that we can then print individually.
The program should only create as many worksheets as there are patients, and should automatically delete and create worksheets as patients are added or removed, or have switched rooms.