Create Thick Border Around Rows Based On Similar Data In A Column

  • 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.

Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!