Even So the next portion I am having difficulties to do following the mass copy and paste has operate I want A different code which will update column A appropriately such the Job num from sheet 2 will fill in to every in between tasks two and ten,000 I've connected https://www.biluznaopt.com.ua/top-mass-copy-paste-excel-secrets/