Hi.
I have a workbook, and everyday I track daily changes in about 20 different categories. Everyday I duplicate the current worksheet and name it whatever todays date is example 10-28-21.
Instead of changing the formula in each of the 20 cells (I just change it in one and drag down, but...) would I be able to have a field with a date so anytime I put the name of the sheet I want it reference the formula will know to look at that sheet.
I'm attaching an excel file showing this a little better. Thanks in advance.
I have a workbook, and everyday I track daily changes in about 20 different categories. Everyday I duplicate the current worksheet and name it whatever todays date is example 10-28-21.
Instead of changing the formula in each of the 20 cells (I just change it in one and drag down, but...) would I be able to have a field with a date so anytime I put the name of the sheet I want it reference the formula will know to look at that sheet.
I'm attaching an excel file showing this a little better. Thanks in advance.