+ Reply to Thread
Results 1 to 7 of 7

A Dynamic User-Input Table?

  1. #1
    Registered User
    Join Date
    08-01-2018
    Location
    Ann Arbor, MI
    MS-Off Ver
    2016
    Posts
    96

    Smile A Dynamic User-Input Table?

    Hello

    I am wondering if it is possible to make a dynamic table in excel where the user can put in different inputs. I am making an excel dashboard where the user is able to input information for three different scenarios. I'd like that they can input KPIs A,B,C for each different scenario in the same table to save space.


    So, When they go to the drop down they can select, "Scenario 1" and the table will be blank for the user to fill in A,B,C. Then they can go back to the drop down and click "Scenario 2" and then again fill in A,B,C. All of the data could actually be stored in a different background calculation excel sheet in the same workbook.

    Is something like this possible?

    Any help is greatly appreciated. Thanks in advanced!

  2. #2
    Forum Guru Olly's Avatar
    Join Date
    09-10-2013
    Location
    Darlington, UK
    MS-Off Ver
    Excel 2016, 2019, 365
    Posts
    6,249

    Re: A Dynamic User-Input Table?

    Why reinvent the wheel? Scenario Manager is native functionality which does exactly as you require.
    let Source = #table({"Question","Thread", "User"},{{"Answered","Mark Solved", "Add Reputation"}}) in Source

    If I give you Power Query (Get & Transform Data) code, and you don't know what to do with it, then CLICK HERE

    Walking the tightrope between genius and eejit...

  3. #3
    Registered User
    Join Date
    08-01-2018
    Location
    Ann Arbor, MI
    MS-Off Ver
    2016
    Posts
    96

    Re: A Dynamic User-Input Table?

    Hi Olly,

    Thanks for your response! I have actually never heard of Scenario Manager. I'll do some research and come back if I have any questions.

  4. #4
    Registered User
    Join Date
    08-01-2018
    Location
    Ann Arbor, MI
    MS-Off Ver
    2016
    Posts
    96

    Re: A Dynamic User-Input Table?

    Hi again,

    I want this excel sheet to work like a Dashboard. I would not be the user and I need it to be as user-friendly as possible. I am not sure that having a scenario manager function would help this; especially because I need all of the data stored in a background calculation to feed into multiple charts

  5. #5
    Forum Guru Olly's Avatar
    Join Date
    09-10-2013
    Location
    Darlington, UK
    MS-Off Ver
    Excel 2016, 2019, 365
    Posts
    6,249

    Re: A Dynamic User-Input Table?

    It's just... you want to design functionality to make things easy, but you're asking broad questions for help on here... that suggests that your solution will be harder to implement and support, than native functionality. Not trying to pour cold water on your idea, but you might get better support if you ask much more specific questions, once your project is further advanced.

  6. #6
    Registered User
    Join Date
    08-01-2018
    Location
    Ann Arbor, MI
    MS-Off Ver
    2016
    Posts
    96

    Re: A Dynamic User-Input Table?

    Sorry, but I think there is a misunderstanding. My project is pretty advanced at this point. There are several charts that switch between scenarios for given data sets within the dashboard.

    I am only wondering if it is possible to create a dropdown menu (Dropdown1: choose between Scenario 1, Scenario 2, Scenario 3) where you pick "Scenario 1" and then all of the answers you store in cells B2:D5 are stored in a separate sheet (Scenario 1 worksheet). Then, the user can pick "Scenario 2" and all of the answers are cleared and then the new inputs are moved into the Scenario 2 worksheet. Does this make sense?

    Scenario Manager seems to be designed for someone who is using their own excel sheet whereas the dashboard I am creating is only going to be used by other users without my help. I do not think that they will just know to go to Scenario Manager to add in their scenarios.

  7. #7
    Registered User
    Join Date
    08-01-2018
    Location
    Ann Arbor, MI
    MS-Off Ver
    2016
    Posts
    96

    Re: A Dynamic User-Input Table?

    Would it be possible to link the Scenario Manager to a dropdown?

+ 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. [SOLVED] Chart with dynamic range based on user input
    By vizzkid in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 10-25-2018, 10:36 AM
  2. Generating a Dynamic table based off user input
    By Sparkplug90 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 04-29-2017, 06:33 PM
  3. [SOLVED] Project Timeline with Dynamic Date Range Based on User Input
    By Rollinstone12 in forum Excel General
    Replies: 2
    Last Post: 10-28-2012, 10:07 AM
  4. Dynamic Range with user input
    By jj72uk in forum Excel General
    Replies: 4
    Last Post: 03-24-2011, 04:40 PM
  5. User Input to Split the Table
    By rakesh1 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 10-19-2010, 08:11 PM
  6. Generating dynamic charts based on the user input
    By shivan4u in forum Excel Charting & Pivots
    Replies: 4
    Last Post: 02-13-2006, 08:43 AM
  7. [SOLVED] Dynamic calculations according to user input
    By David in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 10-11-2005, 04:05 PM

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