Yes, by adding a new CustomerID I want it to create another Row in the CustomerData Worksheet and the only fields that should be created or populated are the CustomerID, Created Time & Date, and Entered by. All other cells should be blank.

thanks for your quick response!