KanBan.xlsx

I am trying to find a formula that will enter the info from the cells on the spreadsheet into the Product ID card template text boxes.

So for A54 or A55 I would like those inserted into both Text Box 1 and Text Box 12. B54 or B55 would go to Text Box 2 and Text Box 11. C54 or C55 would go into Text Box 3 and Text Box 13. And so on so forth for each column along the row for that part.

For the perfect functionality, I would like to be able to add each row of info for each part, enter all the ones I need to do, then have them all print out in the template one by one. At this point I have to do each one manually, and this could potentially save me hours.

Please give me some ideas if you have them.

Thanks,

Craig