+ Reply to Thread
Results 1 to 2 of 2

Creating a table with user input

  1. #1
    Registered User
    Join Date
    07-18-2011
    Location
    Washington, DC
    MS-Off Ver
    Excel 2007
    Posts
    24

    Creating a table with user input

    I am new to this and am trying to read a user's input which consists of a start date where the month is in B6 (a drop down list: JAN, FEB, MAR, etc.) and the year YYYY is in C6 and an end date thats in the same format directly below in B7 and C7. I then want to display the results as column headings(MMM-YY) starting in row B9. For example, B6 = JAN, C6 = 2011, B7 = MAR, C7 = 2011 I want JAN-11, FEB-11, MAR-11 to appear as column heading.

  2. #2
    Forum Expert
    Join Date
    07-20-2011
    Location
    Mysore, India.
    MS-Off Ver
    Excel 2019
    Posts
    8,710

    Re: Creating a table with user input

    Please enter the following formula in cell B9.
    =B6&"-"&C6

    Please enter the following formula in cell C9.
    =B7&"-"&C7

    You will get result.

    Thanks.

+ 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