Hey Guys! I'm something of a n00b when it comes to Excel but I was wondering if it's possible to do the following as illustrated in this image:
Calc Within Calc.jpg
Sample Sheet
Flyout Sheet.xlsx
The actual sheet I'm using is full of data and I want to create clickable mini calculators within each. A formula won't do because I need to have text and editable cells.
The screen real estate has been maxed out hence the need for flyouts - just as if you click on a cell and get the comment.
I've noted a thread where the flyout is presented but you can't run any calculations or input data on the flyout.
I'd be grateful for any advice!
Bookmarks