Nevertheless The subsequent component I am struggling to accomplish once the mass copy and paste has run I need A further code that may update column A accordingly this kind of the Job num from sheet 2 will fill in to every between responsibilities 2 and 10,000 I have attached http://mtthub.org/groups/the-single-best-strategy-to-use-for-mass-copy/