I have a document list on one worksheet which are hyperlinked. (150 docs)
I have another worksheet using formula to extract these documents into a shorter list but the hyperlink is not brought across, only the text.
Is there a piece of code,formula or format command to make the hyperlink copy across.
I have another worksheet using formula to extract these documents into a shorter list but the hyperlink is not brought across, only the text.
Is there a piece of code,formula or format command to make the hyperlink copy across.