Forum Discussion
Copy countif formula
I have individual tabs named for each day of the year that will be populated with daily data. Eg. tab called 2023-04-29, 2023-04-30 and so on. The Summary tab will be used to capture data from each d...
There is no direct way to do that.
You can use INDIRECT and a list of all tabs to do that but I do not recommend that.
I would instead propose that the workbook should be organized differently. In particular, I would recommend a master data entry sheet/tab and include in that entry table the day.
THEN you can easily create daily report(s) AND any type of summaries much easier.
You can use INDIRECT and a list of all tabs to do that but I do not recommend that.
I would instead propose that the workbook should be organized differently. In particular, I would recommend a master data entry sheet/tab and include in that entry table the day.
THEN you can easily create daily report(s) AND any type of summaries much easier.