List only cell with Values

[Closed]
Report
-
Posts
4476
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
August 2, 2020
-
Hello,

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.

Thanks, Janet

1 reply

Posts
4476
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
August 2, 2020
768
Apply filter on not equal to 0 and copy the visible rows
When you paste, make sure you choose pastespecial and choose values