Nonetheless Another portion I'm having difficulties to do after the mass copy and paste has run I need Yet another code that will update column A appropriately such which the Occupation num from sheet 2 will fill in to every between tasks two and 10,000 I've hooked up the sheet http://mtthub.org/groups/not-known-facts-about-mass-copy-lodz-1852082622/