I just need to clarify the headings that you want to use as there are, for example, in your post, some in sheet 3 that are not in sheet 1. Also, in sheet 1, you refer to "Home Health Referral" and "Home Health Completed" and in sheet 2 "Referred to Home Care" and "Home Care Completed". Are these supposed to be the same items? (I have made them the same items in the table below as there does need to be consistency for any code to execute correctly. Please advise if this is not correct). To extract the data from sheet 1 to the other sheets, all the required headings for the various activities need to be in sheet 1, which I have assumed will be your "Input" sheet. I've just re-arranged them as follows:-
Sheet 1 Sheet 2 Sheet 3
Patient Name Patient Name Asthmatics Seen
Date Seen Date Seen Asthma Ed.
DOB DOB Sick Calls(#)
Age MH/AH/Athena# ED Visits(#)
MH/AH/ Athena # Reason For Visit Direct Admits
Dx Last Clinic Visit ED Referrals
Reason for visit Last ED Visit ED Referrals Seen
Last Clinic Visit Last H'lisation In Patient Referral
Last ED Visit
ED Visits(#) Sick Calls(#) In Patient Referrals Seen
Last H'lisation Rx Calls(#) Referred to Home Care
Direct Admits Provider Home Care Completed
ED Referral ED Referral
ED Referrals Seen Referred to Home Care
Asthmatics Seen Home Care Completed
Home Contact Info
In Patient Referral
In Patient Referrals Seen
Referred to Home Care
Home Care Completed
Please advise if this is how you were thinking of setting out the three spread sheets.
I would also recommend creating a unique Patient ID (numeric or alpha numeric) which would simplify data transfer rather than use a Patient's name as you may have, for example, five Bob Jones on your list which would obviously then cause confusion with the data transfer.
Let us know your thoughts.