Nevertheless Another portion I'm battling to accomplish after the mass copy and paste has run I would like One more code that can update column A accordingly such the Position num from sheet 2 will fill in to each in between jobs 2 and 10,000 I have connected the sheet http://rivonirecruitment.co.za/?p=34277