Report

Auto-create tabs from list and template

Ask a question teacup001 1Posts Wednesday October 11, 2017Registration date October 11, 2017 Last seen
Hello,

I have a workbook with two tabs:

1. Tab name 'Index' If information is input into C4, then I need a tab created
2. Tab name 'Template' is the book to copy, but it is a template and needs information from the previous tab 'Index' :
B2 uses =+Index!A4
H1 uses =+Index!C4
H2 uses =+Index!D4
H3 uses =+Index!B4

So instead of manually linking to the Index page and inserting copies of the template tab, is there a way for it to automatically create a workbook full of tabs?

Please let me know if clarification is needed. Thanks!

Member requests are more likely to be responded to.

Members can monitor the statuses of their requests from their account pages.

A CCM membership gives you access to additional options.

Not a member yet?

Sign up now. It takes less than a minute and is completely free!