Excel Macro (?)

Project Budget (AUD)

Project Description:
have an Excel sheet. What I need to do is create a URL string that will be used to connect to an online form and pre-populate the form using the data in the excel sheet.
There are 4000 unique records, so 4000 unique URLs/hyperlinks.
I want a macro "button" that will create the URL and write it to a column alongside the record.
As the string / URL is likely to be very long, I would like the macro to rename the URL to a simple generic name, but it should maintain the string hyperlink

Skills required:
Project offered by: