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.
Bookmarks