Auto sort and hide rows with zero quantity

[mamapear]

Hello,

I have data pulling into a worksheet from a previous worksheet. There is data populating rows 3-107 and columns A-I.

I want to sort the whole table by the values in column G in descending order, then hide any rows that contain a zero value in the G column.

Is there a way to do this automatically? I know how to do this manually, but I want the workbook user(s) to get the information automatically.

Thank you in advance for any guidance you are able to provide.

 

[sandy666]

you can try PowerQuery (Get&Transform)

select your table (Ctrl+T) - choose with/without headers
from Data - select From Table
it will open PowerQuery Editor with your table
select your column
filter by 0
sort descending
Close&Load (to the sheet)
---
after that you can use Ctrl+Alt+F5 to refresh QueryTable if any new data will be added into the source table

 

[JoeMo]

Welcome to the Forum!

This macro will do what you requested.

Sub mamapear()
Dim R As Range, c As Range
Set R = Range("A3").CurrentRegion
Application.ScreenUpdating = False
R.Sort key1:=[G3], order1:=xlDescending
For Each c In R.Columns(7).Cells
    If c.Value = 0 Then c.EntireRow.Hidden = True
Next c
Application.ScreenUpdating = True
End Sub