I have 1 Workbook with 1 worksheet with data...say Workbook 1 Worksheet Data
Have 50 worksheets in another workbook...Workbook 2 Worksheets "1","2","3",4,..until Worksheet 50
If F1 and G1 are populated with numbers and are <> 0 I need to copy H1, O1, P1, Q1 in B6, D6, D8 and D5 in worksheet "name in E1"
If they are not numbers or different of 0 analize next row doing the same analisis
If F2 and G2 are populated with numbers and are <> 0 I need to copy H2, O2, P2, Q2 in B6, D6, D8 and D5 in worksheet "name in E2"
.
.
Continue to do the same until Row 250

If F250 and G250 are populated with numbers and are <> 0 I need to copy H250, O250, P250, Q250 in B6, D6, D8 and D7 in worksheet "name in E250"

Note that always will be populated in B6, D6, D8 and D5....and the worksheets where the data goes will depend of the name are in Column E

Ex.

Woksheet Data

--------A-------E-------F-------G-------H-------O-------P-------Q

1-------0-------Tom-----0-------0-------5-------8-------0-------9
2-------0-------Ron-----8-------54------6-------7-------8-------9
3-------0-------Bill---100-----35-------4-------0-------3-------2
.
.
8-------0-------0-------0-------0-------6-------0-------8-------9
.
.
.
250-----0-------Jo------7-------23------12------13------14-----15

RESULTS

Worksheet Ron
--------A-------B-------C-------D-------E-------F-------G-------H
4
5 9
6 6 7
7
8 8

Worksheet Bill
--------A-------B-------C-------D-------E-------F-------G-------H
4
5 2
6 4 0
7
8 3

Worksheet Jo
--------A-------B-------C-------D-------E-------F-------G-------H
4
5 15
6 12 13
7
8 14

Thank you a lot