Hi Paul,

Thank you for that - that's spot on and works perfectly when I run it . Is there anything that can be added to it which would allow it to automatically run when the user leaves the table?

If I want to modify the code across other tables (using the same logic i.e. the formfield is blank in column 3) which sections would need updating, I understand the table reference, but I can't figure out the rest