I currently have two user forms to populate one master data sheet. We process refunds for patients and insurance companies. One form is for patient data to be entered the other is for the Insurance refunds however both go to one master data sheet. I would like to include to the patient form two seperate form letters to be populated with selected criteria when entered in the user form, a button to print each of those forms, then clear the forms when print is complete. Same with the insurance form.
Example: User form for Patients has 14 fields. 10 of those fields must go to the master spreadsheet, 6 of the 14 go to the patient letter & 5 fields to the Patient Form. All done with one time entry into the user form. When data is complete a button currently on the form is selected and populates the master. I would like a button to use to "Print Patient Letter" and one to "Print Patient Form" When the User form is cleared after the last of the three buttons is selected I would also like that to clear the Pring Patient Form and Print Patient Letter for the next Patient to be entered.
I currently have the function to populate the master and using it just fine however would like to eliminate multiple times of data entry into three different forms. Using the user forms also eliminates "user error" on non-experienced users in excel for us.
Any help and or advice is appreciated!
Thanks in advance!
Bookmarks