https://skydrive.live.com/redir.aspx...F14BAD69FF!104

when you move say the first patient down two or three rows sometimes the formulas will follow, or erase there reference to other cells, maybe there is a better way to run the formulas that im not aware of, ive mostly just fiddled untill i got it right.....hopefully someone here knows how to do this better than i do....

biggest problem is that it must work as a shared workbook.


at the moment each cell must be cut and pasted individually due to the issue of protected cells stopping the highlight of a whole row at once