Create a Master sheet to then transpose and export spreadsheets

loribear180

New Member
Joined
Apr 13, 2021
Messages
24
Office Version
  1. 2016
Platform
  1. Windows
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.

1623160542165.png
1623160562943.png
 

DanteAmor

Well-known Member
Joined
Dec 3, 2018
Messages
13,571
Office Version
  1. 2007
Platform
  1. Windows
Works for me.
You can try changing those shape-textboxes for my original idea, in cells.
Or with textbox control ActiveX
 

Excel Facts

Move date out one month or year
Use =EDATE(A2,1) for one month later. Use EDATE(A2,12) for one year later.

loribear180

New Member
Joined
Apr 13, 2021
Messages
24
Office Version
  1. 2016
Platform
  1. Windows
@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

Well-known Member
Joined
Dec 3, 2018
Messages
13,571
Office Version
  1. 2007
Platform
  1. Windows
Let me know if it works for you or you changed the design and need help with the new design.
 

Forum statistics

Threads
1,141,048
Messages
5,703,928
Members
421,321
Latest member
blusky4

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top