troubleshooting Question

Creating New Sheets based on list and template

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

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
test_newsheet.xlsx
ASKER CERTIFIED SOLUTION
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