+ Reply to Thread
Results 1 to 4 of 4

Using drop down list to populate table from another sheet

  1. #1
    Registered User
    Join Date
    01-15-2021
    Location
    Calgary, Canada
    MS-Off Ver
    2016
    Posts
    2

    Using drop down list to populate table from another sheet

    Hi everyone. For the attached workbook, I am trying to use the options in the drop down list in cell B3 to populate the sales table from B6:D19 with the corresponding data listed for that particular week on the "Data" sheet. So, as I change the week that I select from the drop down list, the table will adjust accordingly to the corresponding week in the data sheet.
    I didn't fully understand the solutions for previous posts along the same lines and how I could make it work for my workbook. I'm not a very experienced excel user, so I apologize if it's an easy or redundant solution. I really appreciate any advice you can offer. Thank you!
    Attached Files Attached Files

  2. #2
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 7/10/13/16/365 (PC ver 2310)
    Posts
    52,929

    Re: Using drop down list to populate table from another sheet

    Try this in B6, copied down and across...
    =INDEX(Data!B:B,MATCH("week "&$B$3,Data!$A:$A,0)+ROW()-4)
    1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
    2. If your question is resolved, mark it SOLVED using the thread tools
    3. Click on the star if you think someone helped you

    Regards
    Ford

  3. #3
    Registered User
    Join Date
    01-15-2021
    Location
    Calgary, Canada
    MS-Off Ver
    2016
    Posts
    2

    Re: Using drop down list to populate table from another sheet

    Thank you very much for your help, Ford! It seems to be working perfectly. This has saved me so much time and aggravation. Thanks again...I really appreciate it!

    Cheers,
    Daniel

  4. #4
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 7/10/13/16/365 (PC ver 2310)
    Posts
    52,929

    Re: Using drop down list to populate table from another sheet

    Happy to help and thanks for the feedback
    Last edited by FDibbins; 01-18-2021 at 03:28 AM.

+ 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. Replies: 10
    Last Post: 04-03-2018, 02:27 PM
  2. Replies: 16
    Last Post: 01-25-2018, 12:18 PM
  3. [SOLVED] To-Do List: How to populate a sheet if drop-down criteria is met in multiple other sheets
    By jessicawilliams in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 08-09-2016, 08:18 AM
  4. Replies: 5
    Last Post: 09-22-2014, 05:28 AM
  5. Pick table from drop down and populate on other sheet
    By siva venkata in forum Excel General
    Replies: 10
    Last Post: 05-29-2014, 12:34 AM
  6. How to populate a table from drop down list.
    By trumpetman in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 10-14-2012, 12:53 PM
  7. Replies: 12
    Last Post: 09-26-2012, 03:32 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