+ Reply to Thread
Results 1 to 5 of 5

Returning multiple rows from table

  1. #1
    Registered User
    Join Date
    01-30-2015
    Location
    Belgium
    MS-Off Ver
    office 2010
    Posts
    3

    Returning multiple rows from table

    HI,

    I have a table with lots of data. In column 1 I have "week" in column 2 I have "name".
    On a new sheet i would like to return al the rows (every week) based on the "name" i Select from a dropdown.
    Can someone help me please?

    Thnx in advance

  2. #2
    Forum Guru Pete_UK's Avatar
    Join Date
    12-31-2011
    Location
    Warrington, England
    MS-Off Ver
    Office 2019 (still learning)
    Posts
    24,603

    Re: Returning multiple rows from table

    Take a look at my attachment in Post #4 of this thread:

    http://www.excelforum.com/excel-form...ml#post3973305

    It is very similar to what you want to do.

    Hope this helps.

    Pete

  3. #3
    Registered User
    Join Date
    01-30-2015
    Location
    Belgium
    MS-Off Ver
    office 2010
    Posts
    3

    Re: Returning multiple rows from table

    exactly what i need.
    But how did u create this dropdown?
    It is not a form control or a activex?

  4. #4
    Forum Guru Pete_UK's Avatar
    Join Date
    12-31-2011
    Location
    Warrington, England
    MS-Off Ver
    Office 2019 (still learning)
    Posts
    24,603

    Re: Returning multiple rows from table

    It's a Data Validation drop-down, using the list of depts that I created on the other sheet.

    Pete

  5. #5
    Registered User
    Join Date
    01-30-2015
    Location
    Belgium
    MS-Off Ver
    office 2010
    Posts
    3

    Re: Returning multiple rows from table

    Ok, found it. --> Data Validation --> list

+ 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: 3
    Last Post: 06-16-2014, 03:13 PM
  2. Returning multiple lines from a table
    By sky1710 in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 03-28-2014, 10:38 AM
  3. Replies: 1
    Last Post: 07-31-2013, 04:11 PM
  4. [SOLVED] Certain rows of a VLOOKUP table are returning as N/A. but why?
    By Solidstan in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 01-26-2013, 06:46 PM
  5. [SOLVED] Returning all rows from table that match certain criteria
    By carbonn in forum Excel General
    Replies: 6
    Last Post: 11-11-2009, 07:42 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