i'am trying to create a database which has all the information i need in sheet 2 and a cover sheet in sheet 1.
i have used V look up so that when i type in a location in a table on the cover sheet, all the information i need is brought from sheet 2 into the table.
the problem i have is that i have hyperlinked text in sheet 2 which takes me to a document, but in the cover sheet when i type in the location the text comes up but no hyperlink
does anyone know how to v look up a hyperlink?
Bookmarks