Edit existing macro to affect a larger span of cells.

Good evening,

My spreadsheet is for a pharmacy and it is used to track a patients medications. The macro used on the form takes the DIN number for each medication and finds the graphic on our system to populate a cell below. I have added 10 additional rows for patients that have more meds to manage for a total of 20.

The form currently populates the pictures for each of the meds from 1-10 in row 25 no problem, I now need to it populate the cells for meds 11-20 in the cells on row 27.

Help would be most appreciated.

Regards,

James

I sincerely appreciate your support with my document. I was able to get to the pharmacy today to try it and it works fantastic, thank you! the only thing that requires adjustments is the photos...they are really small. even if you could direct me so that I can tweak the photo sizes that would be amazing.

Thank you again for your support and your time.

James

I managed to figure out the sizing on my own. Thank you again for your support!

James