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