Hey everyone, I'm new here.

I just took over a position in the hospital where part of my duties are printing out monthly patient info in a cute little sheet to give to them. The data for each month is stored on seperate sheets within the workbook (one sheet per month). I have to select the patient's name from a drop-down list in cell B2 on a seperate results sheet (INDI), which updates another sheet (RCARD) that I then print.

So currently I have to go back and forth between the last two sheets described, clicking the next option on the INDI drop-down box and then going back to RCARD to print, for every single patient.

I was hoping to find a way to make a macro that would allow me to loop through all the options in the box, selecting them and then printing off the RCARD worksheet for each selection. I've tried modifying several examples that I found online, with no success. Can anyone help, please?