So I have one sheet that we use for a Bill of Material list, Column A5-A? contains the part numbers of this job, there can be any number of parts then column B5-B? contains the amount quantity for each part, Now some of the values can be zero. I am looking for a way to transfer the information from sheet1 to sheet2 while leaving out any of the rows that have a zero quantity. And Im just drawing a blank, any help would be appreciated.


Thanks
Chris