Solving cell range based on multiple criteria

Hi Alf,

Thank you for your quick reply.

I've tried to test run your loop, but unfortunately I keep getting Compile Error as shown in picture.

Untitled-1.jpg

Solver was already ticked in the VBA References. Any idea what the problem might be?

Thank you.