Excel Macro (?) - open to bidding

Avg Bid (AUD)
Project Budget (AUD)
$30 - $250

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:
About the employer:
Public Clarification Board
Bids are hidden by the project creator. Log in as the employer to view bids or to bid on this project.
You will not be able to bid on this project if you are not qualified in one of the job categories. To see your qualifications click here.

$ 144
in 3 days
Hire finecodervw
$ 200
in 10 days
$ 55
in 0 days
$ 50
in 3 days
Hire bharanisrihari
$ 35
in 1 days
Hire microk
$ 45
in 3 days
$ 49
in 3 days
$ 34
in 1 days
$ 83
in 3 days
$ 35
in 2 days