Nevertheless The subsequent component I'm struggling to perform after the mass copy and paste has operate I need Yet another code which will update column A appropriately such that the Position num from sheet 2 will fill in to every between duties two and ten,000 I've connected the sheet and http://rivonirecruitment.co.za/?p=34333