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
Bookmarks