Even So the next portion I am having difficulties to do following the mass copy and paste has operate I need A further code that can update column A appropriately such the Career num from sheet 2 will fill in to every in between duties 2 and ten,000 I have http://rivonirecruitment.co.za/?p=34297