Excel Macro (?)

This project has been awarded to nayabsiddiqi for $50 AUD.

Get free quotes for a project like this
Employer working
Awarded to:
Skills Required
Project Budget
$50 AUD
Total Bids
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

Looking to make some money?

  • Set your budget and the timeframe
  • Outline your proposal
  • Get paid for your work

Hire Freelancers who also bid on this project

    • Forbes
    • The New York Times
    • Time
    • Wall Street Journal
    • Times Online