Hi again dear Wizards,

Please help me to automate my spreadsheet.

I want to automate cell A1 for example that if I encode particular data and data itself will convert to a hyperlink that will direct to a particular website.

If a A1 contains letters "SAFM"+any number like (SAFM556483055) it will convert to a hyperlink and whenever I click it, it will direct me to this website address [http://mysaf2.safmarine.com/wps/port...afmarine/Home]

and, MAEU999999999 to http://www.maerskline.com/appmanager...g3_trackSimple

and MSCHH9999999 to http://www.mscgva.ch/tracking/index.html

Please... and thank you sooooo much!