Hi Steve
I have just done Patient 1 only. Let me know if this is what you need.
Please bear in mind that on Patient 1 you had a space after the "1" which would prevent VLookup from working.
Also if you dont want anyone to change data in column I, suggest you protect that column so no changes can be made.
Good luck.
Tony
Last edited by OTPM; 05-02-2013 at 03:30 AM.
|