Page 1 of 1

[Solved] Hide a row based on a cell - No Macro knowledge

PostPosted: Thu Jul 23, 2020 12:14 am
by amirlamdan
I have an order sheet with a big wine list on column A and quantity to order on column B.
I would like to copy to a new sheet all the wines that have a value other than 0 or EMPTY in column B.

So the new sheet should show only the wines that are ordered on the 1s sheet.

I have never used Macro before so a complete novice.
Thanks

Re: Hide a row based on a cell - No previous Macro knowledge

PostPosted: Thu Jul 23, 2020 1:27 am
by FJCC
There is no need for a macro; you can use the filter function. I assume the list of wines has the headers Wine and Quantity. Select the cells you want to affect and then choose the menu Data -> Filter -> Standard Filter. Set the Field Name to Quantity, the Condition to >, and the Value to 0. Click More Options and select the box Copy Results To. In the box to the right and one row down enter the name of the cell you want to results copied to, e.g. Sheet2.A1. Click OK and the data will appear at the chosen sheet and cell.

Re: Hide a row based on a cell - No previous Macro knowledge

PostPosted: Thu Jul 23, 2020 2:07 am
by amirlamdan
That works.
Thanks.