Dear sir,
This job can be finished using formulas or VBA, as you prefer. But I need only info about row 25, where is "Mandatory-Action-Individual" but levels 3-7 are empty. Everything else is clear, based on the combination in columns A-C, levels 1-7 will be filled, and if A is "Optional", then everything is filled with "Optional'.
And because I'm new at this site, positive feedback is most important for me right now.
Best regards,
Marko