Hi,
We have a workbook that has a template sheet within it that is to be copied and used when a new entry is required. For instance, a every day will require a new sheet. Within this workbook there is a summary page that will collate the data entered and return summary values for analysis. Is there any way that when you create a copy of the Template sheet for the new day, that the formula in the Summary sheet automatically adds in the new sheet. I have attached an example. If I were to copy a new sheet from the Template for Wednesday how could I ensure the values in it are automatically in the Summary tab formulas, this is to reduce manually having to add the new sheet data into the formula on the Summary sheet.
Thanks!
Bookmarks