Posts by richardwing


    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.