I was wondering if you can assist with a issue I am having with a project I am working on.
I am creating a timesheet form and I require some sort of automation or something similar.
In my sheet I require if one cell is change it populate another cell with something that is already logged elsewhere.
for example in my sheet if I change the project manager name to : John smith from my dropdown list(contact list), in another column or sheet to John Smith = UK.
I hope I am making sense I have attached my work so far and make a comment to try and make it clearer.
Thank you in advance.