Forum

Try the attached. I converted all the tables to Excel Built-in Tables and added some named ranges. Code assigned to the button, via click event, i...

Thanks again Velouria. I did that and tested by changing "Include Gears" from "No" to "Yes" for Automatic, and adding a new Transmission_Type "Indi...

Yes I could do that, and just hope that the need to add the No of gears and "Sp" always applies only to MTM and does not change to being needed for ex...

Thanks Velouria. I had already considered that and tried it. However that does not add the No. of Gears and "Sp" to all the "MTM"s, I would stil...

This will add a comment to cell A1 when its value changes via cell validation, rather than using a message box. The comment will become visible whe...

I found a fix! Here it is, incase anybody else suffers the same issue. When you open Excel select the Personal Macro Workbook and go to: Vie...

Thanks Riny. A couple of tweaks (the actual file already had a column headed "Index", it is a catalogue) and all is working perfectly. I will le...

Thanks Riny, that looks perfect! I will add your M code to the M code in my actual file and see if it works there, I am confident it will.

Sorry, but based on the mass of data scattered all over the place for each Factory and your explanation in your opening post I cannot work out what it...

Probably, or in Power Query. But without seeing your data it is impossible to say for sure.

Much better, Riny! INDIRECT should be avoided whenever possible due to it volatility.

Try this in B43 =IF(INDIRECT("Table_Matrix["&Person&"]")="X",XLOOKUP(SubNrs,Table_Tasks[subnr],Table_Tasks[task],""),"") Note I made B41...