Copying a template sheet's content to a series of newly created sheet tabs.

**ZootlyData** · 02-16-2016, 07:27 PM

Hey Richard,

Thanks again, but I am still getting the same error. I have attached an updated excel sheet that has your updated code included. Any ideas? Thanks again.

**Richard Buttrey** · 02-17-2016, 04:01 AM

Hi,

You still haven't created the range name "SheetNames". See my first comment in my last post.
Currently this should cover I2:I6 on the Summary.

If you periodically add new rows to the summary then it would be advisable to make this range a dynamic range name so that it automatically adjusts. If so then define it thus:

Formula:

=OFFSET('Summary'!$J$2,0,0,COUNTA('Summary'!$J:$J)-1,1)

Copying a template sheet's content to a series of newly created sheet tabs.

LinkBack

Thread Tools

Rate This Thread

Display

Hybrid View

Re: Copying a template sheet's content to a series of newly created sheet tabs.

Re: Copying a template sheet's content to a series of newly created sheet tabs.

Thread Information

Users Browsing this Thread

Similar Threads

hyperlink of newly created sheet

[SOLVED] Worksheet Activate when user selects sheet NOT when sheet is created from a template sheet

[SOLVED] Pulling data from a main sheet and placing it onto a newly created sheet

Getting Macro to reference newly created sheet

Updating Summary Sheet from Newly Created Sheet

How to copy to newly created sheet and save as PDF?

Automatically transferring data from one sheet to newly created sheet in a workbook

Bookmarks

Bookmarks

Posting Permissions