add hyperlink with the URL hardcoded in the code

[saidineshbabu]

There is a column whose values should be suffixed with a common URL and add hyperlink to it. Can some one help in getting this through macro?

Sample sheet attached;

1st sheet has the original raw table.

2nd sheet has the table which I need as a output.

Thanks in advance

[jeff]

add hyperlink with the URL hardcoded in the code (http://www.mrexcel.com/forum/excel-questions/736753-add-hyperlink-url-hardcoded-code.html)

[bakerman]

Dear saidineshbabu
Welcome to the forum.
Please read the forum rules regarding crossposting.

http://www.excelfox.com/forum/f25/message-to-cross-posters-1172/