Nevertheless The subsequent component I am battling to try and do once the mass copy and paste has operate I would like A further code that can update column A appropriately such that the Work num from sheet two will fill in to each between tasks two and ten,000 I've http://mtthub.org/groups/the-basic-principles-of-mass-copy-business-partner-sap/