I'm trying to find a way to automate a few things to save some time:
-Use the data in an input tab to create multiple tabs/documents with a saved template
-Then use data in that same tab to fill out a few details
The data table is a list of units in a building with bedroom/bathroom information and occupancy
The template I have is for inspections, each unit needs to be inspected, the forms are then printed out so it doesn't need to stay in excel if that's easier. I just don't know where to start.
I'm figuring I'll need to use a macro but that's new for me, I don't know where to start but once I do I should be able to run with it.
Need to create multiple tabs based on data in table
Its good to see that you have been working on this yourself whilst waiting for a reply. Well done!
Thanks for sharing your resolution also.
Be careful with the loop type code in your last post as, although it works fine, there is no check in the code for duplicate names and Excel may throw up an error message warning you that it won't allow sheets to have the same name. However, if you delete the names in your list as you go, then there shouldn't be any issues.
Again, well done!
P.S.: The following thread may be of interest to you:-