your p.s. noted - I am suitably admonished and have marked my crossposting as solved.

and that code pretty much does exactly what I need it to do so MASSIVE thank you!

question - is there a way that the info can be copied into merged cells A1, D1 and G1 without overwriting the 'Type:', 'Ser no:' and 'User:' text?