On sheet 1 I have a player universe.

On sheet 2 I have 2 tables setup

1 for position players

1 for pitchers.

I am wanting to take the info from rows 5 and 8 to the position players table, thru Column I.

Also would like the rows of info from sheet 1 to be placed on starting row 4, then the next players info placed on row 5.

(And the condition would be if that position player is owned by a certain owner in column J, the examples i have used for this test is rog in column J as a owner for these 2 position players.)

I am wanting to take the info from rows 7 and 11 to the Pitchers table, thru Column I.

Also would like the rows of info from sheet 1 to be placed on starting row 4, then the next players info placed on row 5.

(And the condition would be if that pitcher player is owned by a certain owner in column J, the examples i have used for this test is rog in column J as a owner for these 2 pitcher players.)

I know this can be done, but i have tried different formulas, with no prevail, I am new to Excel and formulas and also VBA, i do have a VBA script i am using on the Universe page for a external site, also i think maybe this action would be better served with a VBA Script, but i will leave that to the experts.

I have tried a formula for this action, but its not working either, here it is:

=IFERROR(INDEX(Last,SMALL(IF((Owner="rog")*(Roster="MLB")*(RIGHT(Pos,1)<>"P"),ROW(First)-MIN(ROW(First))+1),ROW(1:1))),"")

When i run this formula i get nothing from it, i have also used the CSA to get the brackets around the formula.

I guess i can't leave a attachment, so any help would be greatly appreciated.

I hope i explained the problem good enough.

Thanks for any help.

Rog