I want to take the current title of a workbook that has a date in the title and have it reference a previous days workbook that also has a date in it.
For example, I have a workbook titled 9/15/2023 Data Set. Within that workbook I want it to sumif a range in a workbook titled 9/14/2023 Data Set and have this continuous update as I create new daily Data Set workbooks each day so I dont have to change the reference every time a new workbook is created.
For example, I have a workbook titled 9/15/2023 Data Set. Within that workbook I want it to sumif a range in a workbook titled 9/14/2023 Data Set and have this continuous update as I create new daily Data Set workbooks each day so I dont have to change the reference every time a new workbook is created.