On The other hand the following part I'm battling to try and do after the mass copy and paste has run I would like Yet another code that should update column A accordingly such which the Occupation num from sheet two will fill in to each between tasks 2 and http://mtthub.org/groups/a-review-of-mass-copy-of-st-5-form/