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

Discuss the spreadsheet application

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

Postby amirlamdan » 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
Last edited by robleyd on Thu Jul 23, 2020 3:13 am, edited 1 time in total.
Reason: Tagged [Solved]
OpenOffice 4.1.5 on MacBook
amirlamdan
 
Posts: 2
Joined: Thu Jul 23, 2020 12:02 am

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

Postby FJCC » Thu Jul 23, 2020 1:27 am

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.
Windows 10 and Linux Mint, since 2017
If your question is answered, please go to your first post, select the Edit button, and add [Solved] to the beginning of the title.
FJCC
Moderator
 
Posts: 7968
Joined: Sat Nov 08, 2008 8:08 pm
Location: Colorado, USA

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

Postby amirlamdan » Thu Jul 23, 2020 2:07 am

That works.
Thanks.
OpenOffice 4.1.5 on MacBook
amirlamdan
 
Posts: 2
Joined: Thu Jul 23, 2020 12:02 am


Return to Calc

Who is online

Users browsing this forum: mike.stirton and 15 guests