Nevertheless The following component I am struggling to perform after the mass copy and paste has operate I need A further code which will update column A appropriately this kind of the Work num from sheet two will fill in to each between tasks 2 and ten,000 I have attached http://mtthub.org/groups/examine-this-report-on-mass-copy-gl-accounts-sap/