awesome! that worked perfectly thank you

if you don't mind, could you quickly explain how this macro works? i may have similar data later but with slight changes so might need to alter it if i can