formula or code copy data from sheet to another based on cell value

[Hasson]

hello
I have data in first sheet what I want copy to the second sheet with ignore any customer has value is 0 in col E , it doesn't make difference formula or code
first

1.xlsx
	A	B	C	D	E
3	item	customer	credit	debit	balance
4	1	ali	300	400	100
5	2	omar	300	500	200
6	3	mahmoud	700	700	0
7	4	ami	250	250	0
8	5	alla	800	800	0
sh1

expected result in second sheet

2.xlsx
	A	B	C	D	E
3	1	ali	300	400	100
4	2	omar	300	500	200
sh2

 

[JackDanIce]

Try formula in A3 of second sheet:

Other.xlsm
	A	B	C	D	E
3	1	ali	300	400	100
4	2	omar	300	500	200
sh2

Cell Formulas
Range	Formula
A3:E4	A3	=FILTER('sh1'!$A4:$E8,'sh1'!$E4:$E8<>0)
Dynamic array formulas.

 

[Fluff]

@JackDanIce The OP is using 2016 & so doesn't have the filter function.

@Hasson how about

+Fluff 1.xlsm
	A	B	C	D	E
1
2
3	item	customer	credit	debit	balance
4	1	ali	300	400	100
5	2	omar	300	500	200
6	3	mahmoud	700	700	0
7	4	ami	250	250	0
8	5	alla	800	800	0
9
Sheet1

+Fluff 1.xlsm
	A	B	C	D	E
1
2	item	customer	credit	debit	balance
3	1	ali	300	400	100
4	2	omar	300	500	200
5
6
Sheet2

Cell Formulas
Range	Formula
A3:E5	A3	=IFERROR(INDEX(Sheet1!A$4:A$8,AGGREGATE(15,6,(ROW(Sheet1!$E$4:$E$8)-ROW(Sheet1!$E$4)+1)/(Sheet1!$E$4:$E$8<>0),ROWS(A$3:A3))),"")

 

[JackDanIce]

@Fluff Maybe they'll be inspired to upgrade!

Thanks for the heads-up, I was confusing Data Get and Transform (2016) vs dynamic formulas more recent, d'oh!

 

[Hasson]

@Fluff thanks for your answering

 

[Fluff]

You're welcome & thanks for the feedback.