Forum Discussion
Conditional Cells based on Gender and Using forms to create sheets?
I am trying to design a spreadsheet to help our medical coordinator keep track of when the last annual appointment was for the individuals we serve. I had a few ideas and i wasn't sure if they're...
There is a lot here but what I would recommend for you to get started is to think of setting up the sheets as 1 for patient entry and another for appointment entries. So the Patient sheet would have 1 row for each patient and all their 'fixed' information and the Appointment sheet can have an entry for every appointment with the date, patient ID, type, and any other relevant info.
Then you can use pivot tables and power pivot tools to create all kinds of reports if you want.
As in the attached example you can also have some formulas on the patient sheet to extract the latest/last appointment of each type.
I hope this concept gets you going and maybe we can tackle additional questions as they come up.