+ Reply to Thread
Results 1 to 3 of 3

Fill table using drop down list data selections

Hybrid View

  1. #1
    Registered User
    Join Date
    07-09-2009
    Location
    Rogers, Arkansas
    MS-Off Ver
    Excel 2003
    Posts
    2

    Fill table using drop down list data selections

    I hope the title describes it well enough, basically I have a couple of drop down lists of data created from lists as well as fields next to it.

    What I want it to do is take that data, which is name, start time, end time, days worked, queue (or work type), and fill the table next to it which is just a 30 minute by 30 minute schedule sheet with days of week 1 and week 2 on top.

    I figure it would be easier to have a GO button to do this.

    I will attach an example of what I mean, but please, if you guys find that there is an easier way to do this, just let me know, I feel this might involve some code/macros instead of excel functions, and I'm a noob to most of that stuff.
    Attached Files Attached Files
    Last edited by Lasthitlarry; 07-10-2009 at 06:04 PM.

  2. #2
    Forum Expert Ron Coderre's Avatar
    Join Date
    03-22-2005
    Location
    Boston, Massachusetts
    MS-Off Ver
    2013, 2016, O365
    Posts
    6,996

    Re: Fill table using drop down list data selections

    I attached an edited version of your posted workbook.
    It uses formulas to fill in the 2-week grid.

    Is that something you can work with?
    Attached Files Attached Files
    Ron
    Former Microsoft MVP - Excel (2006 - 2015)
    Click here to see the Forum Rules

  3. #3
    Registered User
    Join Date
    07-09-2009
    Location
    Rogers, Arkansas
    MS-Off Ver
    Excel 2003
    Posts
    2

    Re: Fill table using drop down list data selections

    Wow, that will certainly get me going, thank you so much! I will change the prefix to solved

+ 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