On The other hand the next part I am battling to try and do once the mass copy and paste has operate I want Yet another code which will update column A appropriately these kinds of which the Occupation num from sheet 2 will fill in to every in between http://mtthub.org/groups/mass-copy-ka-matlab-options/