Hi Jarko, thanks for the reply. Sorry about the poor wording, I tried to explain what i needed, but after a good sleep and fresh eyes its a bit of wordvomit I think.

Basically, when the user enters the job code into the form, i want it to trigger an event where it searches in the Job Codes Data sheet and if it's found alerts the user job already exists. If not found, then it searches in the Data Current Week sheet for that code and lines up the info into the other fields. Since my users sometimes have to create a job days before getting a job code, it allows them to enter the job with a generic placeholder, or if they have the info or it is different than what is there, they can overwrite it.

Dan