Macro to Copy and Paste Rows to new sheet bases of cell value greater then 0

[ECook2021]

I am trying to copy rows from a master estimate sheet (sheet 2) and paste them into a master PO sheet (sheet 5) based off positive value in Quantity column B11:B283. I do not need it to copy the entire row just values in columns B:G.

When it is pasted I want it to populate the table in the master po sheet.

This process needs to be automated for specific uses.

Thank you

 

[JamesCanale]

I did it all in one sheet, but that's easily changed.

MrExcelPlayground2.xlsm
	A	B	C	D	E	F	G	H	I	J	K	L	M	N
1	Item No.	Quantity	Unit	Desc	Cost Code	Unit cost	Total		Quantity	Unit	Desc	Cost Code	Unit cost	Total
2	1		sqft	Thing	1	$ 10.00	$ -		100	ft	Other thing	2	$ 20.00	$ 2,000.00
3	2	100	ft	Other thing	2	$ 20.00	$ 2,000.00		500	cuyd	A	3	$ 30.00	$ 15,000.00
4	3	500	cuyd	A	3	$ 30.00	$ 15,000.00		100	ft	C	5	$ 1,000.00	$ 100,000.00
5	4		each	B	4	$ 50.00	$ -		50	each	E	7	$ 500.00	$ 25,000.00
6	5	100	ft	C	5	$ 1,000.00	$ 100,000.00
7	6		ft	D	6	$ 50.00	$ -
8	7	50	each	E	7	$ 500.00	$ 25,000.00
Sheet40

Cell Formulas
Range	Formula
I2:N5	I2	=FILTER(B2:G8,B2:B8>0,"")
G2:G8	G2	=F2*B2
Dynamic array formulas.