I have a collection of data that extends across many days [months now actually] where I store the daily detail in a straight table format on a sheet which is named for the day [ie "02-05-2002" for May 2nd dd-mm-yyyy format]. I am then referencing and counting various data occurences on a data summary sheet.
What I would like to do is to be able to drag/fill the formulas on the summary sheet as I add new days data sheets to the workbook. At the moment i have to drag the cells and then edit them to update the sheet names to point at the correct data.
The date appears in a cell on the data sheet. Is there a way to reference the date and use that to recognise the correct data sheet? An example of the formulas I have is :-
In this instance I am counting occurrences of data for a particular state on the days worksheet. I've tried a few ways using different function combinations but I can't identify a solution. I'm sure there is one.