[Solved] Hide a row based on a cell - No Macro knowledge
Posted: Thu Jul 23, 2020 12:14 am
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
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