Hide rows with 0 value in cell (temporary)

[cripopes]

Hello again gents,

I have a work project which is way over my excel modest skills. I have a large list of products and some have values and some have 0 value for now. To sort out this list for more efficiency I'm looking to temporarily hide those until I need them, eventually with a button or something. Below you have the file.


Capture.JPG


The value in column "D" is based on what I insert in columns "B" (+ to value in D) and "C" (- to value in D) using this:

Please Login or Register  to view this content.

You can find the file below.

Cheers.

[PCI]

What about a filter and unselect value 0 in column "D" ...?

[nankw83]

Hi cripopes & welcome to the forum,

Two questions
1. If the value is zero then hide row - value in which column ? D or all (B,C,D) or anyone of (B,C,D) ?
2. Is your above code working as needed ? It confusing, if I enter 5 in 'C' then 'D' becomes -5 & if I enter 5 in 'B' then 'D' become zero which makes sense until now, if I enter 5 again in 'C' then I end up with 5 in 'B', 5 in 'C' but -5 in 'D'

[cripopes]

Hi cripopes & welcome to the forum,

Two questions
1. If the value is zero then hide row - value in which column ? D or all (B,C,D) or anyone of (B,C,D) ?
2. Is your above code working as needed ? It confusing, if I enter 5 in 'C' then 'D' becomes -5 & if I enter 5 in 'B' then 'D' become zero which makes sense until now, if I enter 5 again in 'C' then I end up with 5 in 'B', 5 in 'C' but -5 in 'D'

Yes.. so how this is meant to work.. column B is "how many pieces I produced/ day" - column C is "how many pieces I sold/ day" - column D is "how many pieces I have left at the end of the day". ( and repeat this every day, so basically I will leave column "D" untouched after I insert the initial stock which I have currently).

However I managed to work out a solution to my hide/ unhide issue.

I created 2 buttons - one for hide and one for unhide.

Hide button -

Please Login or Register  to view this content.

Unhide button -

Please Login or Register  to view this content.

It might not look professional but it helps me organize better.

Thoughts for improving this?

[nankw83]

This is another method using AdvnacedFilter instead of looping through each cell/row

Please Login or Register  to view this content.