Microsoft Excel
--
Questions
--
Followers
Top Experts
Tabbed sheets from a list
Hi experts,
I have a word sheet which was a pain to fill in so I have re-created it in excel tabbed "Template".
I want to add a list of users to a separate sheet, then using the "Template" create a sheet for each user, including their name in a field, say A3.
Is it possible and if so, please point me in the right direction.
Thanks
Andy
I have a word sheet which was a pain to fill in so I have re-created it in excel tabbed "Template".
I want to add a list of users to a separate sheet, then using the "Template" create a sheet for each user, including their name in a field, say A3.
Is it possible and if so, please point me in the right direction.
Thanks
Andy
Zero AI Policy
We believe in human intelligence. Our moderation policy strictly prohibits the use of LLM content in our Q&A threads.
ASKER CERTIFIED SOLUTION
membership
Log in or create a free account to see answer.
Signing up is free and takes 30 seconds. No credit card required.
I would suggest that instead of making so many copies of the template you should just keep the template and work a way to change the name. This has the advantage that
- you can always change the template in only one place whenever required. You would not have to change all the generated sheets.
- you do not have to worry about having difficulty scrolling to the desired sheet
- troubleshooting/error checking is easier.
One way of changing the data in the template is to use a data validation list in the name cell.
- you can always change the template in only one place whenever required. You would not have to change all the generated sheets.
- you do not have to worry about having difficulty scrolling to the desired sheet
- troubleshooting/error checking is easier.
One way of changing the data in the template is to use a data validation list in the name cell.
Thanks guys,
Traveling at the moment so not had a chance to look at this for a few days.
StephenJR, will give the code a try. It's a macro, correct?
ssaqibh, not asking for spoon feeding here, but your concept sounds interesting. Anything on actual implementation?
Traveling at the moment so not had a chance to look at this for a few days.
StephenJR, will give the code a try. It's a macro, correct?
ssaqibh, not asking for spoon feeding here, but your concept sounds interesting. Anything on actual implementation?
Hello guys,
Back from my travels and am able to get this settled. Any feedback from my questions above will be answered by return.
Thanks
Andy
Back from my travels and am able to get this settled. Any feedback from my questions above will be answered by return.
Thanks
Andy
EARN REWARDS FOR ASKING, ANSWERING, AND MORE.
Earn free swag for participating on the platform.
Just what I needed, thanks.
Microsoft Excel
--
Questions
--
Followers
Top Experts
Microsoft Excel topics include formulas, formatting, VBA macros and user-defined functions, and everything else related to the spreadsheet user interface, including error messages.