[VBA] Delete rows under certain conditions

[Thompsonnl]

I have a sheet (made by some SQL/VBA/Excel expert long time ago). In this sheet I can enter a production run number ("Productieorder / PO") and it will show me all necessary components with current stock, clearance status, total needed stock etc. pulled form an insanely large database.
I would like to make this list easier to work with with the click of a button. But unfortunately I am far from a SQL/VBA/Excel expert.

Because images say more than a thousand words;

Explanation;
Article - Mentions all the needed articles for this PO (can be up to 70 different ones from a total of 1000, all with different codes)
Needed - Shows the needed amount for this PO
Available - Shows stock of said article/batch combo
Batch - Shows the corresponding batch of said article
Blocked - Yes or No
Total need - Total needed amount of this article for all open production runs, not just the one checking right now


What I would like to do/2 examples;

The PO I am checking needs 792 grams of GR00100.
I have a total of 6 batches available for a total of 266.179 grams, none of which are blocked.
My total need for all open PO's is 80.401 grams.
The total need is covered by the total available stock.
Hide all GR00100.

The PO I am checking needs needs 2970 grams OF GR00926
I have a total of 3 batches available for a total of 555.500 grams, of which 550.000 grams is blocked.
My total need for all open PO's is 15.539 grams
The total need is _not_ covered by the total available stock (since 550.000 grams is blocked)
Show all GR00926.

So if total need > total available (not blocked) I do want to keep these rows visible.

If I am not mistaken, the process should be as following;
1) Hide all Blocked:Yes rows.
2) Identify the rows belonging to 1 article (for example GR00100 - Row 5~10)
3) Add total Available stock for Row 5~10
4) Compare total Available stock for Row 5~10 to total need
5) Mark GR00100 as + (or - in case of not meeting the requirements)
6) Repeat steps 2~4 for every unique article
7) Show all Blocked:Yes rows.
8) Hide all "+" marked article

I can make a new button which performs step 1. But unfortunately that is where my skills end.
Hoping you can point me in the right direction on how to approach improving this worksheet

 

[Thompsonnl]

Bump, since it got lost under many pages of questions

 

[Thompsonnl]

Another bump. I know it is a rather extensive question but some pointers in the right direction would already help!

 

[Thompsonnl]

Bump

 

[Thompsonnl]

Bump... I'm starting to get the feeling this might not be possible?

 

[Thompsonnl]

Bump