Hi Terry,



In that case, you'll need a macro-based solution. See attached. There's a 'Document Open' macro in it that automatically updates the first table in the document, which is assumed to have four coulms:
• Patient name
• Operation date
• Post-Op days elapsed
• Discharge date
If you input a date in column 2 (Operation date) column 3 (Post-Op days elapsed) will be updated next time you open the document. Inputting a date in column 4 (Discharge date) will stop column 3's value updating beyond that date. Changing column 4's value will cause the column 3's value to be re-assessed.

Attached Files

PatientRecords.doc (38.5 KB, 97 views)

__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]

I really can't thank you enough!

We actually don't need a discharge date column, although that was a very nice gesture. Our other columns are "procedure, antibiotics and to-do", but I think I can add that myself. I attached a snipping of it to this post. How do I rid of the discharge date column?

I think I'm going to read up on Visual Basic coding this weekend. It would be extremely helpful if you would explain how your macro works. I'm sure my resident will ask me to explain how he could incorporate this at the different hospitals he's going to be working at.

Thanks again! You're awesome.

Attached Images

Pt list ex.jpg (38.0 KB, 64 views)