Copying Hyperlinks by column
 

Hi hope someone can help. Is there a way to copy hyperlinks by column into
another workbook wihtou losing the hyperlinks?

I currently have a large workbook & 1 of the columns in this workbook
contains hyperlinks in each cell (which hyperlink to another work book) I
would like to copy all the hyperlinks by column into a differnet workbook in
1 go if possible. However I am currentky having to do this 1 cell/hyperlink
at a time & as you can guess its very manual.
--
N Walton