I have a laborious task of copying data from a list (Book1) into date based templates.
What I am after is some VBA to loop through the data in Book1 and create a new file for each distinct date in the file from the master template.
This is how I see the process:
Find the beginning of the date range in Book1
Get number of rows with that date
Insert date @ D9 in
Insert count of array @ D13 ‘to give a count of rows
Insert Time array @ B20
Insert REF array @ F20
Insert value of ‘35’ @ G20 ‘for length of array
Save file named as date
Next date...ie repeat process until last date.
I have provided attachments for a visual representation
You will see that the first date in the list (colour coded in yellow) has found one row associated with the date 08/12/20 and copied the data over to the relevant cells and saved as a file named as the date ( 08DEC020)
The next date found is 17/12/2020 and so all relevant rows associated with this date (highlighted in green) are copied over to a new template which is then saved as that date (17DEC2020)... and so on for each distinct date occurrence.
The list is variable in length.
The list is sorted in date order for ease of use but may not be presented that way initially.
This seems to be a situation that Excel is crying out for to be automated via VBA (and save my typing fingers and eyesight).
Any knowledgeable people out there can help me with this?