Get a value if difference between two cells is more than 2

[Tintoo]

Am not good at macros and need experts here to help me.

Find below the sample data in sheet named ""[TABLE="class: grid, width: 500"]
<tbody>[TR]
[TD]Name[/TD]
[TD]training 1[/TD]
[TD][/TD]
[TD]training 2[/TD]
[TD][/TD]
[TD]training 3[/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD]goal[/TD]
[TD]actual[/TD]
[TD]goal[/TD]
[TD]actual[/TD]
[TD]goal[/TD]
[TD]actual[/TD]
[/TR]
[TR]
[TD]res-1[/TD]
[TD]8[/TD]
[TD]5[/TD]
[TD]8[/TD]
[TD]6[/TD]
[TD]N/A[/TD]
[TD]N/A[/TD]
[/TR]
[TR]
[TD]res-2[/TD]
[TD]9[/TD]
[TD]8[/TD]
[TD]8[/TD]
[TD]7[/TD]
[TD]9[/TD]
[TD]4[/TD]
[/TR]
[TR]
[TD]res-3[/TD]
[TD]6[/TD]
[TD]5[/TD]
[TD]8[/TD]
[TD]3[/TD]
[TD]N/A[/TD]
[TD]N/A[/TD]
[/TR]
</tbody>[/TABLE]

Data to be populated in another sheet named "trainings required"

[TABLE="class: grid, width: 500"]
<tbody>[TR]
[TD]Name[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]res-1[/TD]
[TD]training 1[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]res-2[/TD]
[TD]training 3[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]res-3[/TD]
[TD]training 1[/TD]
[TD]training 2[/TD]
[/TR]
</tbody>[/TABLE]

What is required:

If the difference between actual and goal is more than 2 then the heading "training 1" should be captured against the respective name in a new sheet. If its N/A then that cells can be skipped.

Contact me at mrsmart2309@gmail.com if any information is required

 

[Tintoo]

Data excel snip Link:

http://tinypic.com/r/ruma6r/9

how Result to populate in new sheet link:

http://tinypic.com/r/fp8ept/9

 

[Tintoo]

Please someone help me.

Am not good at macros and need experts here to help me.

Find below the sample data in sheet named ""[TABLE="class: grid, width: 500"]
<tbody>[TR]
[TD]Name[/TD]
[TD]training 1[/TD]
[TD][/TD]
[TD]training 2[/TD]
[TD][/TD]
[TD]training 3[/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD]goal[/TD]
[TD]actual[/TD]
[TD]goal[/TD]
[TD]actual[/TD]
[TD]goal[/TD]
[TD]actual[/TD]
[/TR]
[TR]
[TD]res-1[/TD]
[TD]8[/TD]
[TD]5[/TD]
[TD]8[/TD]
[TD]6[/TD]
[TD]N/A[/TD]
[TD]N/A[/TD]
[/TR]
[TR]
[TD]res-2[/TD]
[TD]9[/TD]
[TD]8[/TD]
[TD]8[/TD]
[TD]7[/TD]
[TD]9[/TD]
[TD]4[/TD]
[/TR]
[TR]
[TD]res-3[/TD]
[TD]6[/TD]
[TD]5[/TD]
[TD]8[/TD]
[TD]3[/TD]
[TD]N/A[/TD]
[TD]N/A[/TD]
[/TR]
</tbody>[/TABLE]

Data to be populated in another sheet named "trainings required"

[TABLE="class: grid, width: 500"]
<tbody>[TR]
[TD]Name[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]res-1[/TD]
[TD]training 1[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]res-2[/TD]
[TD]training 3[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]res-3[/TD]
[TD]training 1[/TD]
[TD]training 2[/TD]
[/TR]
</tbody>[/TABLE]

What is required:

If the difference between actual and goal is more than 2 then the heading "training 1" should be captured against the respective name in a new sheet. If its N/A then that cells can be skipped.

Contact me at mrsmart2309@gmail.com if any information is required