I'm fairly new to the Excel world, so have no understanding of VB, I've been working thus far in simple cell formulas, however I have a problem and I just can't work out what to do.. Please help someone..
I have a spreadsheet with a list of products in Column A. Column B is Quantity. The user will fill out a sheet on the same workbook which will autopopulate the Quantity column, i.e. there is a formula in every Quantity cell.
For all the Products that have a quantity, i.e. not 0, I want to copy the Product and Quantity and provide it in a list format on another sheet, with no row gaps..
i.e.
Product A,1
Product B,0
Product C,0
Product D,1
would produce a list
Product A,1
Product D,1
Anyhelp anyone could provide I would really really appreciate.
