On The other hand the next portion I am having difficulties to do once the mass copy and paste has run I would like An additional code that will update column A appropriately these types of the Position num from sheet two will fill in to each in between responsibilities http://mtthub.org/groups/the-best-side-of-mass-copy-zwirki/