On The other hand another portion I'm struggling to try and do after the mass copy and paste has operate I need A different code which will update column A appropriately these types of the Career num from sheet 2 will fill in to each between jobs 2 and 10,000 http://mtthub.org/groups/the-smart-trick-of-copy-messages-from-android-phone-to-computer-that-nobody-is-discussing-97375202/