+ Reply to Thread
Results 1 to 2 of 2

How to create a dynamic table based on a range of cells

  1. #1
    Forum Contributor
    Join Date
    03-07-2009
    Location
    Spain
    MS-Off Ver
    Excel 2003
    Posts
    128

    How to create a dynamic table based on a range of cells

    I am creating a number of working days/month table as an assumption for an excel model.

    Right now I have it so the user defines the
    1) Start date of project e.g., Jan 2013
    2) Number of months e.g., 4

    This will then display
    1) Jan 2013
    2) =EDATE(G8,4)

    What I would like to automatically have a table below populate based on the range so the output would be
    Jan 2013
    Feb 2013
    Mar 2013
    April 2013

    If the number of months is set to 2, then only two rows will display. I would like the table to be a max of 30 rows or so.

    Thanks

  2. #2
    Forum Contributor
    Join Date
    03-07-2009
    Location
    Spain
    MS-Off Ver
    Excel 2003
    Posts
    128

    Re: How to create a dynamic table based on a range of cells

    Bump is this possible?

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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