Autofill a template with text or numbers?

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

Pontooner,
Sounds like you would have to do this with VBA. VBA would allow you to say "if the contents of of this cell changes then put the contents of this cell into textbox 1. Its been a long time since I've messed with VBA but I would recommend moving this question to the VBA forum.

Spitzerpl