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.
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.