Thanks, that's just what I needed! How would I write this as a macro
that could be used in a number of sheets and would only be inserted
into the cells if there was something inserted in the data column. i.e.
if the initial column is empty the corresponding cell remains empty.

Thanks very much.


--
phil2006
------------------------------------------------------------------------
phil2006's Profile: http://www.excelforum.com/member.php...o&userid=35092
View this thread: http://www.excelforum.com/showthread...hreadid=559849