Trouble creating a formula or a script, for moving rows of info from universe to sheet2 when conditions are met in a certain column.

[rogcar]

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 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

 

[rogcar]

Any help is greatly appreciated.

 

[rogcar]

Ok here is a table like the spreadsheet just a sample size though:

Universe sheet​

Last Name First Name DOB Age Pos Team Length Salary Player Value Owner Roster Abad Fernando 12/17/1985 28 RP Oak 0 0.00 $2.57 UFA UFA Abreu Jose 1/29/1987 27 1B CWS 0 0.00 $10.62 rog MLB Abreu Juan 4/8/1985 29 RP LAD 0 0.00 $0.00 UFA UFA Aceves Alfredo 12/8/1982 31 RP Bos 0 0.00 $0.00 rog MLB Ackley Dustin 2/26/1988 26 2B/LF/CF Sea 0 0.00 $3.36 rog MLB Acosta Manny 5/1/1981 33 RP NYM 0 0.00 $0.00 UFA UFA Acta Manny 1/11/1969 45 Mgr FA na na $0.00 UFA Mgr Adam Jason 8/4/1991 23 SP KC 0 0.00 $0.00 rog MLB Adames Willy 9/2/1995 18 SS TB 0 0.00 $0.00 UFA AA Adams Matt 8/31/1988 25 1B Stl 0 0.00 $5.03 UFA MLB Adams Ryan 4/21/1987 27 2B Bal 0 0.00 $0.00 UFA UFA Adams Mike 7/29/1978 36 RP Phi 0 0.00 ($0.55) UFA MLB Adrianza Ehire 8/21/1989 25 SS SF 0 0.00 $0.00 UFA UFA Affeldt Jeremy 6/6/1979 35 RP SF 0 0.00 $0.65 UFA AAA <colgroup><col><col><col><col span="2"><col><col><col><col><col><col></colgroup><tbody> </tbody>
sheet 2 = Position Players Table(Position Players only in this table)
Last Name First Name Age Pos Team Length Salary Player Value <tbody> </tbody> <tbody> </tbody> <tbody> </tbody>
Sheet 2 = Pitchers Table(Pitchers only in the table)
Last Name First Name Age Pos Team Length Salary Player Value <tbody> </tbody> <tbody> </tbody>
If a row of info has got the name in column Owner, then it needs to be transfered to sheet 2 and the table it should go in depends on if the player is a pitcher or a position player, like in the example in universe table the name (rog) is in owner column in rows 5, 7, 8, 11. So i need the position players rows (5 AND 8) in sheet 2 in Position Players table, at the starting row in that table ROW(A4).
Same way with the other 2 rows in universe sheet (7 and 11) go to the Pitchers Table. Note: only columns DOB AND ROSTER don't need to be added in sheet 2. Hopefully this helps if i put these tables correctly. Thanks Rog

<tbody>
</tbody>

 

[rogcar]

Am I doing something wrong here, if so please let me know.
Thanks

 

[rogcar]

Ok i am getting nowhere i have looked thru several threads and posts.

All i want to do is get this info in sheet1 A2:I2 into Sheet2 Position Players Table A2:I2 = if "column J" has the name "rog" in it.
Here is the info:

	A	B	C	D	E	F	G	H	I	J
1	Last name	First name	DOB	AGE	POS.	TEAM	YRS	SALARY	Player Value	Owner
2	Abreu	Jose	2/2/2	25	RF	CWS	2	$2.00	$2.50	Rog
3

<tbody>
</tbody>

I have tried this
Code

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

By the way when i run this formula, i get nothing no errors.

Any Help would be Great and appreciated.
Thanks Rog

 

[rogcar]

Can i get someone to point me in the right direction?
The formula i posted in the above thread should work i think, but i am getting nothing, but i am not that experienced at all in excel or vba , so that is why i am asking.
Thanks

 

[rogcar]

Bump it for Info.