Nonetheless The following component I'm having difficulties to accomplish following the mass copy and paste has operate I need Yet another code that will update column A accordingly these the Work num from sheet two will fill in to each between jobs two and ten,000 I have attached the sheet https://billyq988huf2.wiki-cms.com/user