Challenge #66: My Wine Problem

[FRANCK_ROUQUETTE]

Thank you for the exercise - very good to practice iterative macro - attached my solution + solution to Bonus 1 - I used imbricated macro 

[RobertoEstrada]

Here is my solution, for the null and range validations I just added a formula record on it.

[Etienne]

Spoiler

Used a batch macro to process size criteria (6,12, 96). Output in a table to use less tools for output

[CaraI]

I went Bonus - Batch Macro all the way!  Batched my output to a single Excel with one sheet per case price to boot!

Spoiler

[jagdeep_singh85]

PFA my solution

[arjanloogman]

My solution:

The less tools, the better...

Spoiler

Spoiler

 

Did the error conditions and error message in an earlier version, left them out here.

Regards,

Arjan Loogman

[RoDO]

My solution

Spoiler

[JennyMartin]

Spoiler

I remember looking at this a few months ago and being completely stumped! Today I found it quite easy 🙂 Happy my macro knowledge is improving. 

[kmcdaniel]

Here are the guts of my batch macro:

Spoiler