Can you create a macro for this kind of formatting?

Capture.PNG
Capture2.PNG

I have very little experience with macros and was wondering if there was any logical way to format a spreadsheet in the way explained below:

I have attached two separate snapshots of a portion of a spreadsheet I was working on. As you can see in the first snapshot, this is a list of pesticide registrations. If you notice in column A, there are single entries for some registered products, and multiple entries for others (that is because some products contain multiple AIs, so each component of the product gets its "own" entry). I have to manually go in and box these entries, which can take up a lot of time if there are 200+ entries, like with this particular active ingredient there are 267 entries. Simply put, single entries are boxed alone, and multiple entries are boxed together in a single box. You can see this in the second attached snapshot image.
I have a large list of active ingredients that I have to run registration lists for, such as this one, and each time I have to go through the same process of boxing "like" entries. I was wondering if there was any logical way to write a macro for this process, though since the data varies for each registration worksheet, I'm not sure how likely this is. I was just hoping there was some way to "map" this trend of boxing "like" items.

Looks to me as if the "like" entries all have the same value in column A? Is it just the borders you are trying to apply by code to "box" them?

Can you upload a sample workbook? (when making a post, click "Go Advanced" scroll down, click "Manage Attachments", and upload your file).

My guess without a file to test it on is something like this?

Please Login or Register  to view this content.

P.S. Welcome to the forum

Updated for your sheet name, and added the Application.Screenupdating lines at start and end to make it smoother:

Please Login or Register  to view this content.

Lol, well I'm glad it worked out for you! Please remember to mark the thread as solved if this resolves your request? Thanks
Have a great day!