I would like to know how to put a hyperlink in another sheet within the same excel document.
For example:
sheet 1.) list clients - general information
sheet 2.) list clients - financial information
sheet 3.) list clients - technical information
Sheet 1.) for example, the "cell" of client B. should be a hyperlink, so I would like to click and jump to see his financial situation immidiatly instead of scrolling all the way down and click sheet 2.) and find client B.
If possibly I would also like to hyperlink from sheet 2.) client B, to client B. sheet 3 technical information (but don't think that's possible because there is then already a hyperlink from sheet 1 to 2, client B. so the last part is not really important).
But the first part is important, from 1 to 2. Can someone out there please help me?
Thanx!
For example:
sheet 1.) list clients - general information
sheet 2.) list clients - financial information
sheet 3.) list clients - technical information
Sheet 1.) for example, the "cell" of client B. should be a hyperlink, so I would like to click and jump to see his financial situation immidiatly instead of scrolling all the way down and click sheet 2.) and find client B.
If possibly I would also like to hyperlink from sheet 2.) client B, to client B. sheet 3 technical information (but don't think that's possible because there is then already a hyperlink from sheet 1 to 2, client B. so the last part is not really important).
But the first part is important, from 1 to 2. Can someone out there please help me?
Thanx!