Having Said that the following part I am battling to perform once the mass copy and paste has run I want another code that could update column A appropriately this sort of which the Job num from sheet 2 will fill in to every in between responsibilities two and 10,000 http://mtthub.org/groups/how-much-you-need-to-expect-youll-pay-for-a-good-mass-copy/