Peter Muller
Board Regular
- Joined
- Oct 15, 2018
- Messages
- 133
- Office Version
- 365
- Platform
- Windows
In column A, from row 7 to rows 500+ I have a list of clothing and accessories items, with a blank row separating each category.
In column J, from row 7 to 500+ I have the sum of sales figures, relating to the list in Col A.
I am looking for a macro that will hide the rows if the sum result in Col J is less than 1, or 0, but must not hide the separating rows as indicated in col A.
This list will change daily as stock is received or sold
Can you please help me with this.
In column J, from row 7 to 500+ I have the sum of sales figures, relating to the list in Col A.
I am looking for a macro that will hide the rows if the sum result in Col J is less than 1, or 0, but must not hide the separating rows as indicated in col A.
This list will change daily as stock is received or sold
Can you please help me with this.