Power Query Course in Spanish
Thanks Thanks:  0
Likes Likes:  0
Results 1 to 3 of 3

Thread: Bring over more than one column of data based on criteria (all instances)

  1. #1
    New Member
    Join Date
    May 2018
    Posts
    4
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Post Bring over more than one column of data based on criteria (all instances)

    Hi All,

    Long time visitor first time poster. Hoping the experts here can help me with a situation I have. Attached is an example spreadsheet for reference.

    Setup:
    Data Sheet - List of Owner Names, ID's #'s for the car, Type of car, State the car is located in, Color of the car, Qty of cars.
    Names Sheet - List of Owner Names
    Selection Sheet - Drop down box that allows you to select the owner name in Cell A1. A range of cells to be populated, C1:H6 (C1:H1 is a header)


    Need:
    On the Selection Sheet the user selects the appropriate name from the drop down box in cell A1 and the data for that name populates in the range of cells (C2:H6).
    If there is less than 5 entries then the cells should be left blank.


    Notes:
    Each name on the data tab will never have more than 5 entries since it will be populated once a week with the top 5 entries for each name.
    New customer information can be added to the Data tab each week as well as the Names tab.


    Question:
    Is there a formula that will allow me to do this or is there a macro that I can use that will accomplish this?

  2. #2
    New Member
    Join Date
    May 2018
    Posts
    4
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Bring over more than one column of data based on criteria (all instances)

    Sorry, I guess I can't attach a spreadsheet.

    Data Sheet:

    Name CAR ID Car State Color Qty
    John S 123 Charger CA Black 1
    John S 234 S80 CA Blue 2
    John S 567 Accord CA Grey 1
    Bob A 153 Viper FL Blue 2
    Bob A 365 Corvette FL Black 1
    Trey L 785 Challenger TX Dark Blue 1
    Trey L 698 M5 TX Grey 2
    Chris P 785 Viper SC Blue 1
    Michael V 487 Charger WA Red 1
    Michael V 223 Corvette WA White 1
    Michael V 985 WRX STI WA Dark Blue 2
    Michael V 923 XJ WA Red 1
    Michael V 102 S60 WA Black 1

    Names Sheet:
    John S
    Bob A
    Trey L
    Chris P
    Michael V
    < Select Your Name >

    Selection Sheet - Drop down box in Cell A1 to select the name

    Data for the selected name should populate in cells C2:H6

  3. #3
    New Member
    Join Date
    May 2018
    Posts
    4
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Bring over more than one column of data based on criteria (all instances)

    If any further clarifications are needed please let me know. Thanks.

User Tag List

Tags for this Thread

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

 

DMCA.com