Hi,
Let's say you have 3 spreadsheets in one Google Spreadsheet.
This will be embedded into HTML page, so that, people can view the spreadsheet online.
One can create hyperlinks to websites such as CNN, BBC news, etc. When user clicks the link, the site opens up in new window.
But, how to create hyperlinks to sheets in the same speadsheet? I need the formula, with which you can move from one sheet to the other. I know, you can click the sheet tabs, but I want the formula.
Thanks.