Having Said that another portion I'm having difficulties to do once the mass copy and paste has run I need An additional code that could update column A accordingly such the Task num from sheet two will fill in to every between responsibilities 2 and ten,000 I've hooked up the https://marionlgte.dgbloggers.com/40148762/mass-copy-formula-excel-fundamentals-explained