+ Reply to Thread
Results 1 to 7 of 7

Excel MiniSheet Calculator within a sheet / Flyout Calculator

  1. #1
    Registered User
    Join Date
    06-29-2020
    Location
    Colombo
    MS-Off Ver
    The latest Office 365 on Windows 10
    Posts
    4

    Question Excel MiniSheet Calculator within a sheet / Flyout Calculator

    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!

  2. #2
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2404 (Windows 11 22H2 64-bit)
    Posts
    80,859

    Re: Excel MiniSheet Calculator within a sheet / Flyout Calculator

    This is not possible without code, so I'm moving this to the VBA section.

    There is no such version as 360 - it's 365 (days in a year, not degrees in a circle).
    Ali


    Enthusiastic self-taught user of MS Excel who's always learning!
    Don't forget to say "thank you" in your thread to anyone who has offered you help.
    You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.

    Forum Rules (updated August 2023): please read them here.

  3. #3
    Registered User
    Join Date
    06-29-2020
    Location
    Colombo
    MS-Off Ver
    The latest Office 365 on Windows 10
    Posts
    4

    Re: Excel MiniSheet Calculator within a sheet / Flyout Calculator

    Thank you Ali - Bless you!

    And thanks for clarifying it's 365, it's been the kind of year when days and degrees have merged into one!!!

  4. #4
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2404 (Windows 11 22H2 64-bit)
    Posts
    80,859

    Re: Excel MiniSheet Calculator within a sheet / Flyout Calculator

    LOL! Tell me about it ... Hopefully on of our VBA experts will be able to help.

  5. #5
    Registered User
    Join Date
    06-29-2020
    Location
    Colombo
    MS-Off Ver
    The latest Office 365 on Windows 10
    Posts
    4

    Re: Excel MiniSheet Calculator within a sheet / Flyout Calculator

    Hey just to update - I've got someone on Fiverr who agreed to do it for me - let's see how it turns out and I'll repost my experience

  6. #6
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2404 (Windows 11 22H2 64-bit)
    Posts
    80,859

    Re: Excel MiniSheet Calculator within a sheet / Flyout Calculator

    In that case, please share the solution here when you have it.

  7. #7
    Registered User
    Join Date
    06-29-2020
    Location
    Colombo
    MS-Off Ver
    The latest Office 365 on Windows 10
    Posts
    4

    Re: Excel MiniSheet Calculator within a sheet / Flyout Calculator

    So a UserNote was build but sadly it doesn't store the data and I fear it'll cost a bit more to make it complex (only did additions).
    It did however work as a flyout.

    The workaround I'm going with is to do the costings/calculations on another sheet and just link to them. A bit cumbersome and a lot more work but will suffice for now.
    Thank you for your help but if anyone does have a suggestion I'd be happy to hear it

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. print sheet calculator
    By andresor in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 01-03-2019, 04:07 PM
  2. [SOLVED] print sheet calculator
    By jaykers in forum Excel Formulas & Functions
    Replies: 25
    Last Post: 12-27-2018, 01:09 PM
  3. Using a Sheet as a Calculator
    By wildcat16 in forum Excel General
    Replies: 1
    Last Post: 06-02-2016, 04:06 PM
  4. [SOLVED] Time Sheet Calculator
    By ShujaatShahid in forum Excel General
    Replies: 6
    Last Post: 04-07-2016, 02:11 AM
  5. [SOLVED] Sheet Metal Gauge Calculator
    By English Rob in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 03-23-2015, 02:09 PM
  6. Integrated calculator in excel 07 instead of separate calculator
    By Wayne in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 07-26-2006, 11:20 AM

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1