I have looked at a tables before, however they affected something negatively which I cant recall currently. Maybe it was column headers, conditional formatting, something that was a deal breaker. Thanks for the suggestion.

The scope needs to be limited to VBA solution. Modifying the sheet is not viable solution as this is corporate workbook which is distributed and used at multiple locations and for continuity and familiarity what the user sees should not be modified.

Thanks again.