Dear excel boffins,
I have a macro that filters some rows out based on a cell being less than zero.
99% of the time, that's fine.
There is on occasion a reason to unhide 1 or 2 of the hidden ones. Ill explain in more detail below.
<tbody>
</tbody>
The macro filters out row 3 at the moment because it filters out rows with 0 or less in them. What i would like to do instead is to take to total of columns 3 and 4 and filter on that.
The end result would be that if the total of columns 3 and 4 are more than 0 then it will not get filtered out.
Thanks in advance for help.
Kind Regards,
Nasser
I have a macro that filters some rows out based on a cell being less than zero.
99% of the time, that's fine.
There is on occasion a reason to unhide 1 or 2 of the hidden ones. Ill explain in more detail below.
CompanyX | Xcode | 1 | -1 |
CompanyY | Ycode | 0 | 2 |
CompanyY | Ycode | 2 | 0 |
CompanyZ | Zcode | -1 | 1 |
<tbody>
</tbody>
The macro filters out row 3 at the moment because it filters out rows with 0 or less in them. What i would like to do instead is to take to total of columns 3 and 4 and filter on that.
The end result would be that if the total of columns 3 and 4 are more than 0 then it will not get filtered out.
Thanks in advance for help.
Kind Regards,
Nasser