Most frequent Formula with looping in multiple Range

[JODomingos]

Hi Friends!

I need to fill a most frequent formula in dynamic range in multiple cells, besides that I would like to autofill right the formula until the last column filled.
Each yellow cell must be filled with the most frequent cell considering the range above, and autofill right for multiples cells. Can I Have a macro for that?

 

[Fluff]

Duplicate Looping with the most frequent cell in collumn

Please do not post the same question multiple times. All clarifications, follow-ups, and bumps should be posted back to the original thread.
Per forum rules, posts of a duplicate nature will be locked or deleted (rule 12 here: Forum Rules).