Hi, can anyone help me with this problem. I want to change my ListBoxes into ComboBoxes beacuse I can change font in them into bigger etc.
Also I would like to simplify a little bit my file by adding a loop generating named ranges or something like this. I'm not sure how to build this concept.

Book1.xlsx

In Attached file in Sheet 1 is something that I have, and in Sheet 2 something that I want to create. The thing is that normally there would be a whole lot of ranges and writing formula like If(A1=something,dothis,If(A2=something2,dothat,If(......., just isn't a solution.

Anyone have experience with creating such things?

In advance thank you for your support!
Regards,
Pawel