I was wondering if it was possible to increase the value of a cell each time a new sheet is created within a workbook. For example, I created a series of events with reoccurring dates (2nd through the 15th), on the next sheet I continued the dates (16th through the 29th). If another user creates a new sheet in the future can the copied sheet then continue the patter automatically (30th and on) without having to change the first date manually?
I would like to use this process for other functions as well such as number the pay periods and so on.
Thanks.