Hello everyone and Happy Friday.

I'm looking for a macro that can automate my simple process. I have a long list of URL's in column A. I visit each webpage, copy two values from a table on said webpage, and paste the values next to the URL in columns B and C. The URL's are very similar in that only the last 6 characters change. example: https://www.website.com/PurchaseCont...Contract=32290

So I can have each full url in column A or just the last 6 characters.

Is this possible? Anyone able to help or point me in the right direction? Any and all help is greatly appreciated!