Get external Data / hyperlink

I have created a spreadsheet that basically gets information copies a sheet from another workbook. This works fine, apart from the hyperlinks which are contained in the orginal sheet. The cell contents "come through" ok, but the corresponding link doesnt..

Is there a way to correct this?

Thanks

Hello mdma (ecstasy?),

Hyperlinks that are bookmarks, reference other areas of the same document, don't copy over. There isn't a setting in Excel or Windows, as far as I know, that you change so the bookmark links will copy. The only way to automate the link copying process is to use VBA.

Sincerely,
Leith Ross

Originally Posted by Leith Ross

Hello mdma (ecstasy?),

Hyperlinks that are bookmarks, reference other areas of the same document, don't copy over. There isn't a setting in Excel or Windows, as far as I know, that you change so the bookmark links will copy. The only way to automate the link copying process is to use VBA.

Sincerely,
Leith Ross

Thanks - I thought as much This will lead me to raise the next question re the VBA - where to start?!

Thanks