The below code performs a search in the sheets of a workbook and then lists the search results on the search page that includes the sheet name and row number where the data is located. I would like to be able to include a link to each of the search results to make it easier to go to the data if a change needed to be made. Can anyone help me with this?
Please Login or Register to view this content.
Try:
Please Login or Register to view this content.
Ben Van Johnson
That is exactly what I needed. Thank you so very much.
The one thing I noticed however is that when you click on the link, it takes you to Cell H2 on the sheet. I'd like the hyperlink to take you to the row number when selected.
Last edited by guitarsweety; 11-30-2023 at 09:54 AM.
I added the below line to pronto Leah's code to get the desired. results. Thank you again for your help.
Please Login or Register to view this content.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks