Okay, first let's make the Data sheet data a dynamic range.
So go to Formula tab, select Define Name. Enter a name, like DataList and then a formula in the source field like:
This now allows you to add to the bottom of the list dynamically.
Now, assuming the dates are in the Dates tab, then change formula in B4 to:
confirmed with CTRL+SHIFT+ENTER and copied down
and change formula in C4 to:
entered with just ENTER and copied down.
Then copy again from B4:C19 and paste to top left of each other group.
Bookmarks