Ok here is what I want to do, if anyone can help:

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 am pretty sure this can be done, but I evidently don't have the smarts to do it, any help is greatly appreciated, on the formula to do these actions.
Thanks Rog.

Attached Files

Testformulaforsheet2pitcherposition.xlsm (323.4 KB, 10 views)

Filter by Owner/Position, copy, paste values.

Thanks for responding gebobs.
What i am trying to do is have the rows transferred to sheet 2 if conditions are met in sheet 1

I have come up with a formula just recently i think that should work, but it isn't, maybe you could enlighten me on this formula.
I am new to this type action, so bare with me if you would.

Heres the formula i have put in sheet 2 A4
=IFERROR(INDEX(First,SMALL(IF((Owner="rog")*(Roste r="MLB")*(RIGHT(Pos,1)<>"P"),ROW(First)-MIN(ROW(First))+1),ROW(1:1))),"")

EDIT: By the way i forgot to mention when this sheet is all done their will be 14 team pages to copy and paste the rows to, i am just trying to get the formula correct before i start adding the 14 extra sheets, with about 100 rows to each sheet, so maybe you can see why i would rather use a formula to do this instead of the copy and paste action.

Thanks for your time.
Rog

Attached Files

Testformulaforsheet2pitcherposition2.xlsm (324.0 KB, 15 views)

Just a question for someone?
Would this action be better done with a formula or be done with a VBA script to handle this situation?
the top post is what i am talking about.
If so can it be done with a script and stay true to itself for the entirety, because i have a real problem getting a formula for this action, maybe I need to go back for some lessons, IDK.
Thanks