Nevertheless The following part I am battling to carry out after the mass copy and paste has operate I want A different code that can update column A appropriately this sort of the Occupation num from sheet 2 will fill in to every in between jobs two and 10,000 I've http://mtthub.org/groups/5-simple-techniques-for-copy-massama/