With a few adjustments that seems to do the trick thanks!
Is there a way of making the named ranges more dynamic? I know of the
counta formula so it goes to the end of the data when you add more,
the only problem for me being that my columns are filled with if
formulas that are taken into account using the counta formula. Is
there an alternative?
Thanks,
Simon