Populating Data from one Worksheet to another with conditions

[Ngerengere]

I have a data table on one worksheet.



[TABLE="width: 500"]
<tbody>[TR]
[TD="align: center"]Job Title<strike></strike><strike></strike>[/TD]
[TD]Department[/TD]
[TD]Course1[/TD]
[TD]Course2[/TD]
[TD]Course3[/TD]
[/TR]
[TR]
[TD]Bagging Supervisor<strike></strike>[/TD]
[TD]Packhouse[/TD]
[TD]Yes[/TD]
[TD][/TD]
[TD]Yes[/TD]
[/TR]
[TR]
[TD]Bin Filler<strike></strike>[/TD]
[TD]Yard[/TD]
[TD][/TD]
[TD]Yes[/TD]
[TD]Yes[/TD]
[/TR]
</tbody>[/TABLE]

[TABLE="width: 1057"]
<tbody>[TR]
[TD]Table above is an example of Data sheet but has much more data.

Below is second sheet where I want data populated depending on what job position is selected.

Department
Training Course


[TABLE="width: 500"]
<tbody>[TR]
[TD][/TD]
[TD](Dropdown List of Positions)eg:Bagging Supervisor<strike></strike><strike></strike>[/TD]
[/TR]
[TR]
[TD]Job Title (Will be linked from Drop Down)eg: Bagging Supervisor<strike></strike><strike></strike>[/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Department[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Packhouse<strike></strike>[/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Training Course[/TD]
[TD][/TD]
[/TR]
[TR]
[TD](Populated from data sheet if a yes was found) Course1[/TD]
[TD][/TD]
[/TR]
[TR]
[TD](Populated from data sheet if a yes was found) Course3[/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]So at a guess need a loop to check for a yes in the job positions row when that job position is selected from dropdown box. and populate the training course name to second sheet as above.[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]