Results 1 to 8 of 8

Populate a list based on a single cell

Threaded View

poppet Populate a list based on a... 04-08-2014, 05:34 AM
XOR LX Re: Populate a list based on... 04-08-2014, 05:39 AM
XOR LX Re: Populate a list based on... 04-08-2014, 06:12 AM
poppet Re: Populate a list based on... 04-08-2014, 06:20 AM
poppet Re: Populate a list based on... 04-08-2014, 06:47 AM
XOR LX Re: Populate a list based on... 04-08-2014, 06:50 AM
poppet Re: Populate a list based on... 04-08-2014, 09:02 PM
XOR LX Re: Populate a list based on... 04-09-2014, 01:39 AM
  1. #1
    Registered User
    Join Date
    04-08-2014
    Location
    melbourne, australia
    MS-Off Ver
    Excel 2007
    Posts
    4

    Populate a list based on a single cell

    Hi, I am helping my son with the display of a quadratic in Excel. I won't go into detail about what he is required to do but essentially I would like to do the following:

    When I enter a value for 'Number of Steps' from a drop down a table is generated with the x values changing accordingly.

    For example:

    Number of Steps 5

    x x^2
    ------------
    0 0
    1 1
    2 4
    3 9
    4 16

    Number of Steps 9

    x x^2
    ------------
    0 0
    0.5 0.25
    1 1
    1.5 2.25
    2 4
    2.5 6.25
    3 9
    3.5 12.25
    4 16

    You will notice that the number of steps is the number of x values that take us up to 4. The 4 is fixed.
    I would be able to work out the maths myself as I am a maths teacher but I was wondering how I could autopopulate the table based on a drop down box selection. If it involves going into VBA then don't worry my son needs to get to grips with what I have done.

    Hope you can help.
    Regards,
    David.

    Edit. The formatting does not seem to work above.
    On the left of each table is supposed to be the x value and on the right is x^2.

    Edit: Thanks for the comment. Changed accordingly.
    Last edited by poppet; 04-08-2014 at 05:40 AM.

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Auto Populate cell based on Drop Down list in another cell (VLookup)
    By alialmoore in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 11-27-2013, 04:07 PM
  2. Populate list from single click, add to list from additional clicks.
    By Pewpewpew in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 07-19-2013, 02:07 PM
  3. Save Multiple Files based on List AND Populate a Cell with value
    By aetedford in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 01-09-2013, 04:25 PM
  4. How to populate cell based on drop-down list attached to the SAME cell?
    By lpteague in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 08-25-2010, 02:01 PM
  5. Populate a cell based on input from a drop down list
    By TroyDurham in forum Excel General
    Replies: 9
    Last Post: 01-19-2009, 09:47 PM

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