Even So the following component I am battling to perform once the mass copy and paste has run I would like A further code that could update column A accordingly these which the Job num from sheet two will fill in to each in between responsibilities 2 and 10,000 I http://rivonirecruitment.co.za/?p=34238