Hello! I want to hyperlink A2 on Order tracking to A2 on Requirments and vice-versa, and I want this to filter to all orders, i.e. A3 Order Tracking to A3 Requirements A4 to A4, etc. My hope is to be able to click on the hyperlink in one sheet and have it take me to that same hyperlink order # on on the other sheet. I tried using $A$2 and copy/pasting formula but it didn't work.
Help is appreciated!
Since you know where the worksheet module is, you can use the worksheet_selectionChange event to take you to the other sheet.
Place this in the worksheet(Order Tracking) module. Alter the code and change the sheet name if you place it in the other worksheet.
Please Login or Register to view this content.
Thanks - I entered the code but how does it hyperlink? Do I need to add a hyperlink function to each cell in Column A on both sheets?
You don't need hyperlinks, did you not try the code?
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
,
Bookmarks