Help cleaning code, and dynamic arrays

[KriZo]

I am complete rookie to VBA, but i have been attempting to write a macro that can generate a list of productions ID's that are fit for production, based on two parameters. A production can only be initiated if it can be produced 100%, no split production is allowed, and the current stock of the part to be produced need to be less than 20% of a years sales.

I have written the following code, which does do what i want it to, but i know it can be written smarter, and with dynamic arrays, cause i never know the excact amount of produciton orders to look through, and how many can be singled out for production.

Please Login or Register  to view this content.

I have attached a sample sheet of how my excel sheet with production overview looks like. Can someone help me rewrite the code to use dynamic arrays? And please make comments as to what is what and so on, so I can learn. Useful articles and guides to dynamic arrays are also more than welcome to be shared, so can nail this VBA programming eventually.

[CK76]

Something like below?

Please Login or Register  to view this content.

[KriZo]

Just tried it, it does excactly what it want it to do. My god did i use a lot of code to do the same, but I guess it will eventually get better

Thank you very much, as I expected it could be done much easier and simpler, and I was proven right. And thank you for the comments, it is very easy to understand the process then.

Something like below?

Please Login or Register  to view this content.