print macro help

[jmendenhall22]

What I am trying to do simply stated is push the print button and have sheet2 print then whosmynursedays print then whosmynurseevenings print then according to macro add one day and print sheet2 then whosmynursedays and the whomynurse evenings and so on for the number of days indicated in N2. This has to print in this order as whomynurse sheets are getting their data from sheet2 which is getting its data from sheet1. Sheet2 is the reference sheet for the whosmynursedays sheets it has to change from sheet2 first then print both of the others before adding a day and starting over. Attached is the current macro. Please someone help. I have a basic knowledge of excel and as you can see from the macro the person who made the original for me was kind enough to explain but I have been unsuccessful in adapting it to meet my new needs. Thank you for looking. I can send the file if you need.

tourofdutyrecordshosmynursetestsendable(1).xlsm

Please Login or Register  to view this content.

[JBeaucaire]

Like so, perhaps:

Please Login or Register  to view this content.

Notice the code refers to "Sheet2 " (with a hidden space at the end), that's what your sheet is really named. Watch out for those hidden spaces!