Create a Master sheet to then transpose and export spreadsheets

[loribear180]

Hello! I just need some guidance into what I'm supposed to actually be learning/googling.

I usually create multiple checklists from an Excel 'template' spreadsheet. However, this is too time consuming and I was hoping I could create a simple Master spreadsheet where I could enter all the data and then have Excel automatically transpose (not sure i'm using the correct term) this info and create all the necessary files using the 'template'.

For example, the template includes name, dob, address, etc. I wanted to be able to enter all of this in the Master spreadsheet and then Excel can automatically enter all of this using the template and create/save the multiple files in a specific folder. HELP, i'm not sure where to begin googling or what thread to search for.

 

[DanteAmor]

Works for me.
You can try changing those shape-textboxes for my original idea, in cells.
Or with textbox control ActiveX

 

[loribear180]

@DanteAmor thanks for all your help and patience, it is truly appreciated! Let me see if I can rework their template and if it will still load correctly to the document repository, if so, I'll work with the code you provided and hopefully it'll work with the edits

 

[DanteAmor]

Let me know if it works for you or you changed the design and need help with the new design.