troubleshooting Question

Creating New Sheets based on list and template

Avatar of forever7
forever7 asked on
Microsoft ExcelMicrosoft Office
10 Comments1 Solution71 ViewsLast Modified:

I am looking for an Excel solution.

If I have a base worksheet template (which can change), I need to create sheets identical to the template for a specific list.

Each sheet will be named according to the list and a cell in each of the sheets to be named according to the list also.

The attached file is what I am looking for. For example, sheets will be generated (based on "BASE" template) and named according to column "D" and each sheet will have a named cell according to column "E".

When finished, the list would need to be deleted and just the sheets remaining.

Example excel attached.

thanks in advance
Wayne Taylor (webtubbs)

Our community of experts have been thoroughly vetted for their expertise and industry experience.

Join our community to see this answer!
Unlock 1 Answer and 10 Comments.
Start Free Trial
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 1 Answer and 10 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros