On The other hand the following aspect I am having difficulties to complete after the mass copy and paste has operate I need Yet another code which will update column A appropriately this kind of which the Job num from sheet 2 will fill in to every in between duties http://mtthub.org/groups/mass-copy-zwirki-fundamentals-explained-1537987718/