K
klatimer
I have a workbook template which contains a worksheet for each day o
the month and a summary sheet which totals cells from the dail
worksheets. The problem is that each month does not have the sam
number of days, so the cells of the summary sheet needs to have th
range changed when there is a different number of days.
Is there a way to write a formula to include only worksheets that ar
present - ie when a new file is created from the template i
automatically has worksheets for 31 days - and a worksheet will b
deleted if there are only 30 days. Is there a way to create a formul
so that the file will know there are only 30 days - or 30 worksheets?
Thank
the month and a summary sheet which totals cells from the dail
worksheets. The problem is that each month does not have the sam
number of days, so the cells of the summary sheet needs to have th
range changed when there is a different number of days.
Is there a way to write a formula to include only worksheets that ar
present - ie when a new file is created from the template i
automatically has worksheets for 31 days - and a worksheet will b
deleted if there are only 30 days. Is there a way to create a formul
so that the file will know there are only 30 days - or 30 worksheets?
Thank