i have the workbook attached,

in sheet1 i have a list of hyperlinks in column A, and Names in column
B

what i want to do is in sheet 2

column A - shows the Column A from sheet 1 without the hyperlink

Coulmn B - Shows the Column A Actual hyperlink url

Coulmn C - Shows Column B from sheet 1

i know i need a macro to do this but not sure how to do this, i have
attached a small example of what i need

many thanks

Craig


+-------------------------------------------------------------------+
|Filename: test.zip |
|Download: http://www.excelforum.com/attachment.php?postid=5013 |
+-------------------------------------------------------------------+

--
craigmacca
------------------------------------------------------------------------
craigmacca's Profile: http://www.excelforum.com/member.php...o&userid=36259
View this thread: http://www.excelforum.com/showthread...hreadid=560521