Having Said that the next element I'm having difficulties to carry out after the mass copy and paste has operate I would like One more code which will update column A accordingly these types of that the Task num from sheet 2 will fill in to every in between jobs http://mtthub.org/groups/copy-message-can-be-fun-for-anyone/