Even So another component I am having difficulties to do after the mass copy and paste has run I need Yet another code that will update column A accordingly these types of which the Work num from sheet two will fill in to each between responsibilities two and ten,000 I've Successfully Submitted (Awaiting Approval)