Nevertheless The next component I am having difficulties to complete once the mass copy and paste has run I need A different code which will update column A appropriately such the Position num from sheet 2 will fill in to every between tasks 2 and ten,000 I have attached the http://mtthub.org/groups/mass-copy-paste-excel-secrets/