On The other hand the next section I'm struggling to try and do after the mass copy and paste has operate I want another code that could update column A appropriately such which the Occupation num from sheet two will fill in to every in between duties two and 10,000 http://mtthub.org/groups/how-much-you-need-to-expect-youll-pay-for-a-good-copy-massama/