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.