Create a macro that will insert a hyperlink using the cell information.

Create a macro that will insert a hyperlink using the cell information.

I would like to make a column in my spreadsheet automatically create a hyperlink based off of the information given. 
As an example, if I enter 123456, the automatic end result of the cell should show 123456, while hyperlinking to www.website.com/123456.

I experimented a bit with macros, but am not advanced enough in VBA to understand how to make this happen. 
Is this even possible with macros? Or a different function?