Creating a VBA code for the report

Ladies and Gentlemen,

I have an issue. I am dealing with at least 12k to 15k lines of Data that I am converting to a "usable" report.

This report contains over 120 rules that are defining, who will be responsible. The Rules itself are built with "IF" ruling. Some of them are pretty straight forward, some of them has multiple IFs and comparing 2 - 3 cells to come up with the result.

I made an example (very much simplified) for you guys to have a visual. Unfortunately, I cannot upload the real data due to security issues.

The file i have prepared contains 2 sheets:

Current Scenario with simplified Rules
Goal Scenario with VBA ( I was hoping I could reach this kind of scenario with help of VBA)

Sheet Current Scenario:
Column L: This is some of those straight forward rules
Column M: This is one of those "special rules"

Every month, there are new rules coming I am building in. I would like to have it more structurized and sustainable which I think I can only do if I use "cases" via VBA.

Could you please help me out here? Like an example of the VBA code that I can use as a Foundation for this report?

Thank you very much in advance!

Kind regards

Nxvle

Welcome to the forum! Please take a moment to re-read forum rule #1 and then amend your thread title to something that better explains your problem. Changing your thread title is not optional. Thanks!

No help to be offered, please, until the thread title has been clarified.

In addition to changing the title as Ali has asked note the following.

This is clearly a much simplified example and probably doesn't represent the size or complexity of your actual data. We often find that when we give an answer to what is a trivial non representative example when the solution is used with the real world data it doesn't work because of factors like string length and other stuff which is important but hasn't been mentioned and which causes wasted time and effort.

Therefore upload your real workbook (or at least a cut down copy), and manually add the results you expect to see. Clearly identify which is original data and which are the results and in a note clearly explain how you have arrived at your results.
Anonymise it as necessary to overcome any security/data protection issues. We don't mind how many Donald Ducks, Mickey Mouses or 1 Anytown, Anywhere, names or addresses appear.