Hello,
I am looking to know how to set a thick border around groups of rows that share the same date in column B and span from columns (A - K)
In the example screenshot below I set the borders manually around all of the groupings by date to show the desired outcome.
The data displayed is dynamic and can have a different amount of rows and different sets of dates listed in each row when I run a report.
I have created a macro that gets me this far. I just can't find any resources on how to dynamically put a thick border around rows grouped by similar cell value i.e date.
Any assistance would be greatly appreciated.
Thank you for your time and effort.