So I have an excel sheet made up for our BOM I need a way to either Pull data out into a new sheet or a button to hit save the data into a CVS sheet with multiple information.

This is what the sheet looks like

excel.jpg

On a new sheet I need it to pull C3 as column A1-? Then I need all the part numbers from A5-? and the quantities from B5-? while leaving out any that have a quantity of zero

The new sheet needs a layout like

155,MHDGDS,1
155,MQFL3/4,1

I have been searching all day and trying things without and progress yet.