Forum Discussion
Click on a cell to open worksheet
Hi All,
Is there a way, without using VBA, where I can click on a cell, which opens another worksheet. The answer to that complex calculation on that new or embedded sheet appears in the cell when closed. I need this for tendering on construction work.
Regards
3 Replies
Hi,
Could you explain this part of your question?
The answer to that complex calculation on that new or embedded sheet appears in the cell when closed
However, to open another worksheet from a cell, you can use hyperlinks, to learn more please check out these resources:
https://www.youtube.com/watch?v=5O_bAkKZ5D4
https://www.ablebits.com/office-addins-blog/2014/05/15/excel-insert-hyperlink/
Hope that helps
Thanks for the reply. Please see the attached screenshot of what i'm trying to achieve. Basically want to click on a cell, a worksheet opens, I do the calc, close it, and the answer is in the cell. Is there a way?
If you want to do this natively in Excel, the only way is to create a worksheet containing all calculations you need and the result you want to show in that cell.
Then link the resultant cell to the current sheet.
But the new sheet cannot pop up on top of the current sheet, you can only move to it using hyperlinks.
In the attached workbook, I've tried to approach that in sheet 1 and sheet 2.
In sheet 1 / cell A1, I used a hidden shape and linked it to cell C3 of sheet 2.
Where cell C3 holds the total result.
So, when you click that shape, the link moves you to the next sheet to do any adjustments.
Behind the shape in cell A1 of sheet 1, you will see the linked result, it's done using this formula:
=Sheet2!C1
Hope that makes sense
