Report

Automatically creating sheets based on a Master sheet

Ask a question Tricky_Micky 1Posts Tuesday November 7, 2017Registration date November 7, 2017 Last seen
I am looking for an easy way to create new worksheets, based on a master sheet.

The master sheet is basically a calendar for a week. It has a Monday start date. Each sheet should copy the master, and add a week - ready for data to be entered for the appropriate week.

The Master sheet is from a1::L41
The date is shown at K5 on each new sheet.

I was thinking of having a data setup sheet, where I can add the dates to be created in row a, starting from A6.

So the end result should be that I can enter in the data setup table the new dates to be used, and "at the click of a button" the new worksheets are created for these new dates. Each new sheet should have the date in the name of the worksheet, and in the label of the new sheet, and at K5.

Any ideas :)

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!