Paste Special function and Hyperlinks

M

Madphea

I am creating a 'Parent' Workbook which lists a whole load of documents which
are hyperlinked to PDF files of the actual document. I need to create a few
'Child' workbooks which will list only a few of the documents from the parent
with the hyperlinks.

I wanted to link them so when a document is updated I will only have to
update the parent workbook hyperlink and the child workbooks will update
automatically. I tried to do this with the Paste Special 'Link' selection
which gives me the information I need on the child workbooks however it
breaks the hyperlink to the document.

Does anyone have any ideas on how I could possibly get this to work for me
or am I just going to have to manually update the hyperlinks everytime???

Thanks in advance
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top