Macro to determine the number of blocks to build a wall

I need a macro to determine how many stacked concrete blocks I need to build a wall for a given height?

The concrete block sizes are only available in either 2 feet, 4 feet, or 6 feet high.

What I need: If the input wall height is 12 feet high, I expect the "output" for possible concrete units sizes to build the wall, and to make the 12 feet high (from top to bottom, where row 1 is the top) are the following:

option 1:
Row 1 = 2 feet
Row 2 = 4 feet
Row 3 = 6 feet -- so the total is 12 feet

Or,

option 2:
Row 1 = 4 feet
Row 2 = 4 feet
Row 3 = 4 feet

I am attaching the spreadsheet with an explanation of more rules to follow.

I posted this in another forum yesterday, but did not receive answers as I write:
https://www.ozgrid.com/forum/index.p...-planner-tool/

I appreciate any help.

Administrative Note:

Welcome to the forum.

We would very much like to help you with your query, however it has been brought to our attention that the same query has been posted on one or more other forums and you have not provided the required cross-post link(s) here.

Please see Forum Rule #3 about cross-posting and adjust accordingly. Read this to understand why we (and other sites like us) consider this to be important.

(Note: this requirement is not optional. No help to be offered until the link is provided.)