Find all data using one criteria

  • I have attached a sample file to help with my problem


    I have two worksheets one called output and one called data.


    I would like to populate columns B and C in the output worksheet using data from the data worksheet.


    The user should choose an option from the dropdown menu in cell B2 on the output worksheet sheet.


    I would like to show all the training done in column B and the date the training was done in column C.


    A sample answer would be


    If "A" was selected from cell B2


    [TABLE="class: grid, width: 300, align: left"]

    [tr]


    [td]

    Training

    [/td]


    [td]

    Date

    [/td]


    [/tr]


    [tr]


    [td]

    SI

    [/td]


    [td]

    June-12

    [/td]


    [/tr]


    [tr]


    [td]

    VST

    [/td]


    [td]

    Jan-13

    [/td]


    [/tr]


    [tr]


    [td]

    PWW

    [/td]


    [td]

    Sept-13

    [/td]


    [/tr]


    [tr]


    [td]

    TS

    [/td]


    [td]

    Nov-13

    [/td]


    [/tr]


    [/TABLE]









    I hope someone can help.


    ozgrid.com/forum/core/index.php?attachment/69337/

  • Re: Find all data using one criteria


    I had a solution for you, but apparently I wasted my time since I found you have this cross posted on another board.


    I removed my solution.


    You have 5 posts, you should know the rules.


    You have 38 on the other board and I know they would like the same consideration when it comes to cross posting.


    [cp]*[/cp]

    Bruce :cool: