I'm hoping someone can help me with a problem. I have been searching on the internet for the last couple of days trying to find a solution.
I want to put a hyperlink in spreadsheet A that when pressed will open up spreadsheet B and automatically go to the sheet 3 tab. I have tried many examples that I ran across on the internet with no luck. The hyperlinked spreadsheet always opens up on sheet 1.
If someone could create two excel spreadsheets that work and attach them to this posting then I could download them and use as a template. I would really appreciate it. Thanks