ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Hyperlink Help - want to link to diff sheet, looking for name cursoris highlighting (https://www.excelbanter.com/excel-programming/413400-hyperlink-help-want-link-diff-sheet-looking-name-cursoris-highlighting.html)

GretOgrady

Hyperlink Help - want to link to diff sheet, looking for name cursoris highlighting
 
Have 2 sheets in workbook - one is a schedule by company name of
scheduled hours and one is a schedule by employee showing each client
they are scheduled to (both built off of same info - pivot not an
option). When on the company view, want to be able to highlight an
employees name and click a hyperlink to go to the 2nd worksheet for
their schedule (which will show this company's hours + everything
else). Would also be be nice to have a 'back' click to go to previous
page view by company.

Possible to do with some sort of hyperlink functionality? Saw some
postings but not sure how to make the reference flexible so that the
hyperlink looked to cell the cursor was on...

Hoping someone can help - thanks!


All times are GMT +1. The time now is 11:13 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com