Hi,
Hyperlink can be created like:
Sheets("Sheet1").Hyperlinks.Add Anchor:=Selection, Address:="http://www.excelforum.com/", TextToDisplay:="Forum"
Web page address can contain some values from spreadsheet, without any additional data nobody will able to give you ready solution.
Information can be copied/transfered from excel sheet to web page using VBA. But again - on your super general question just general answers.
Give us more details, web address of form, upload sample file with "different columns" and dummy data.
Bookmarks