Nevertheless Another aspect I am battling to perform after the mass copy and paste has operate I want One more code that should update column A accordingly these the Career num from sheet 2 will fill in to each in between responsibilities 2 and 10,000 I have hooked up the http://rivonirecruitment.co.za/?p=34273