Hi there,
I am wanting to hyperlink text from one sheet to search for that corresponding text on another sheet. I've found how to manually link text to a cell on another sheet but is there a way to make this dynamic and incorporate a search function so i do not have to manually carry out the linking of text to its corresponding cell on another sheet?
ie i want to link the text "library" from cell A3 in worksheet 1 to look up the corresponding cell in column A in worksheet 2 with "library" in it.
Thanks
I am wanting to hyperlink text from one sheet to search for that corresponding text on another sheet. I've found how to manually link text to a cell on another sheet but is there a way to make this dynamic and incorporate a search function so i do not have to manually carry out the linking of text to its corresponding cell on another sheet?
ie i want to link the text "library" from cell A3 in worksheet 1 to look up the corresponding cell in column A in worksheet 2 with "library" in it.
Thanks