VBA for adding borders to a range based on condition?

Hi Kris,

Here is the attachment- it pretty much outlines what I'm shooting for.
Mainly just need to figure out how to get the borders to appear around the perimeter of the first and last row a particular tool number appears in.... the blank rows in between shouldn't have a top or bottom border.

Thanks again.