Hi,

I am new to this site and have never really used vb before. I am trying to make a user form where the user can enter data that then gets saved (imported) into multiple sheets of the excel workbook. The user form has four tabs; three pertaining to independent contractors that are hired and one that pertains to the client and project info. The user can go in and search for a project by project number and the form will fill in the textboxes with the data that is saved out in the worksheets. I am trying to create a save button that will either add a new line of data if the project, client or contractors are new or overwrite the current data if the user changes an of the information. I originally had an export button and a separate update button but could never get the update button to work. I then decided to just have one save button. the code partially works but it takes a while to process and it doesn't complete the code that is there. I have no idea what I'm doing or what I'm doing wrong. Please help!!


CES form - Copy.xlsm