Ask a question Report

Automatically creating sheets based on a Master sheet

Tricky_Micky 1 Posts Tuesday November 7, 2017Registration date November 7, 2017 Last seen - Nov 7, 2017 at 02:01 AM

Excel Ask a question Report

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 :)

Your reply

Reply to this topic

Ask a question