copy specific data from sheet to another based on condition column value

[abdelfattah]

hi,
i have sheet1 contains data from a1: o i would transfer to sheet 2 the amounts each name the amount in sheet1 is col n and name is col o
input

ssss.xlsm
	A	B	C	D	E	F	G	H	I	J	K	L	M	N	O
1	item	swift no	sub	ben	com	add	acc	ch	or	ag	bank no	doc	expense	ammount	name
2	1	04	231	mm	aw	qw2		li	BADR	ff	00300268101563300093	12D	QW1	593,391.72	JHON
3	2	03	231	bb	ad	02/05/1900		al	ggg	uu	00100260030000020027	23	WW	485,520.00	SMITH
4	3		230	dd	ANEP	err		gguy	kkk	56h	00500170401782603257	DE6	WW3	55,758.64	JHON
5	5	04	231	vv	sd	ty		eee	hh	998	00300268101563300093	RT	33	20,000.00	SMITH
6	6	04	231	cc	we	yy		fff	BADR	lpo9	00300268101563300093	FF	55	30,000.00	SARA
SHEET1

Cells with Conditional Formatting
Cell	Condition		Cell Format	Stop If True
I6:J6	Cell Value	=0	text	NO
I5:J5	Cell Value	=0	text	NO
I2:J60	Cell Value	=0	text	NO

output

ssss.xlsm
	A	B	C	D	E	F	G	H
1	LETTERS
2	PROJECTS
3		JHON	SMITH	SARA
4		593,391.72	485,520.00	30,000.00
5		55,758.64	20,000.00
6
7
8
9
10
11
12
13
SHEET2

Cells with Conditional Formatting
Cell	Condition		Cell Format	Stop If True
B4:AF4	Other Type	Icon set		NO
G1:AF2,B1:F1	Other Type	Icon set		NO
B5:AF17,A3:A17	Other Type	Icon set		NO

 

[Fluff]

What version of Excel are you using?
Please update your user profile to show this. Thanks.

 

[abdelfattah]

hi, fluff my version 2010

 

[Fluff]

Can you please update your account settings to show that. Thanks

 

[Fluff]

How about

+Fluff New.xlsm
	A	B	C	D	E	F	G	H
1	LETTERS
2	PROJECTS
3		JHON	SMITH	SARA
4		593391.72	485520	30000
5		55758.64	20000
6
7
8
9
10
11
12
13
Sheet2

Cell Formulas
Range	Formula
B4:D13	B4	=IFERROR(INDEX(Sheet1!$N$2:$N$100,AGGREGATE(15,6,(ROW(Sheet1!$N$2:$N$100)-ROW(Sheet1!$N$2)+1)/(Sheet1!$O$2:$O$100=B$3),ROWS(B$4:B4))),"")

 

[abdelfattah]

great Fluff , it's perfect many thanks

 

[Fluff]

You're welcome & thanks for the feedback.

Please don't forget to update your account details.