Having Said that the following section I am having difficulties to perform following the mass copy and paste has operate I would like A different code that should update column A accordingly these types of that the Career num from sheet 2 will fill in to each in between jobs http://mtthub.org/groups/how-much-you-need-to-expect-youll-pay-for-a-good-mass-copy/