Nonetheless Another portion I'm having difficulties to do once the mass copy and paste has operate I want A further code that can update column A appropriately such the Position num from sheet 2 will fill in to each between responsibilities 2 and ten,000 I have attached the sheet and http://rivonirecruitment.co.za/?p=34295