I've had an idea of an alternative if this isn't possible or clear. Is it possible to have the Snr Op mobile number rich text CC populate based on their name being selected in the drop down by directly quoting both the name and number in the code? It would obviously require manually coding every name and respective number but if there's an easy way to implement this I'd be happy enough. Been bashing my head at this for a day or so and I'm very unfamiliar with VBA.

Have to say, though, the information in these forums has been so helpful already and I've already been able to put things in place that should save people a lot of time so cheers to you guys.