[SOLVED] userform search field from 1 table and enter data into another table

I have a userform that I'm having issues with...It has 4 fields billingjob, billingdate, billingamount & billing notes. I need all 4 of those fields (when the add button is used) to be entered into the last row of table4 in worksheet BILLING LOG. however I want to check table1 on worksheet PROJECTS column C and make sure that the text entered in the billingjob field matches a job number in the PROJECTS worksheet column C.

this is my code right now..attached is a sample

Please Login or Register  to view this content.