However The subsequent component I am battling to accomplish once the mass copy and paste has run I want A different code that can update column A appropriately this sort of which the Job num from sheet 2 will fill in to every between tasks 2 and 10,000 I've hooked http://mtthub.org/groups/not-known-facts-about-mass-copy-lodz-1852082622/