On The other hand the next section I'm having difficulties to complete after the mass copy and paste has run I want An additional code that should update column A accordingly these types of the Occupation num from sheet two will fill in to each between responsibilities two and ten,000 Successfully Submitted (Awaiting Approval)