Forum Discussion
Click on a cell to open worksheet
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