Ignore zero for in last column when copy specific columns from sheet to another

[abdo meghari]

Hi
I want copying specific columns(A,B,C,D,E,K) from STOCK sheet to STOCK1 sheet , but I want excluding item in column B contains zero for adjacent cell in column K
when copy the data I don't want copying formatting I will create manually in STOCK1 sheet so should copy starting from row2 and should update STOCK1 sheet when update STOCK sheet without repeat copy to the bottom .
I need macro to deal with big data

a.xlsm
	A	B	C	D	E	F	G	H	I	J	K
1	ITEM	CODE	BRAND	TYPE	ORIGIN	ST	PT	AT	ALT	RET	NET
2	1	BSJG580120020	BS 1200R20	G580	JAP	20.00	20.00	5.00	2.00		37.00
3	2	BSTG580120020	BS 1200R20	G580	THI	10.00	10.00	5.00			15.00
4	3	BSTR187120020	BS 1200R20	R187	THI	5.00					5.00
5	4	BSJ3158022.5	BS 315/80R22.5	R184	THI	10.00		5.00		5.00	.00
STOCK

a.xlsm
	A	B	C	D	E	F
1	ITEM	CODE	BRAND	TYPE	ORIGIN	NET
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
STOCK1

result

a.xlsm
	A	B	C	D	E	F
1	ITEM	CODE	BRAND	TYPE	ORIGIN	NET
2	1	BSJG580120020	BS 1200R20	G580	JAP	37.00
3	2	BSTG580120020	BS 1200R20	G580	THI	15.00
4	3	BSTR187120020	BS 1200R20	R187	THI	5.00
STOCK1

 

[Sufiyan97]

If you are happy with formula

Try

Book1
	A	B	C	D	E	F	G	H	I	J	K	L
1	ITEM	CODE	BRAND	TYPE	ORIGIN	ST	PT	AT	ALT	RET	NET
2	1	BSJG580120020	BS 1200R20	G580	JAP	20	20	5	2		37
3	2	BSTG580120020	BS 1200R20	G580	THI	10	10	5			15
4	3	BSTR187120020	BS 1200R20	R187	THI	5					5
5	5	BSTR187120020	BS 1200R20	R188	THI	5	20	3			6
6	4	BSJ3158022.5	BS 315/80R22.5	R184	THI	10		5		5	0
7
8
9	STOCK1
10	ITEM	CODE	BRAND	TYPE	ORIGIN	NET
11	1	BSJG580120020	BS 1200R20	G580	JAP	37
12	2	BSTG580120020	BS 1200R20	G580	THI	15
13	3	BSTR187120020	BS 1200R20	R187	THI	5
14	5	BSTR187120020	BS 1200R20	R188	THI	6
15
16
Sheet2

Cell Formulas
Range	Formula
B11:F14	B11	=IFERROR(INDEX($B$2:$K$6,MATCH($A11,$A$2:$A$6,0),MATCH(B$10,$B$1:$K$1,0)),"")
A11:A15	A11	=IFERROR(INDEX($A$2:$A$6,AGGREGATE(15,6,(ROW($A$2:$A$6)-ROW($A$2)+1)/($K$2:$K$6<>0),ROWS($A$11:A11))),"")

 

[abdo meghari]

thanks for that. I hope from the experts to provide macro too.