Nonetheless The next part I'm having difficulties to carry out once the mass copy and paste has run I need A further code that could update column A appropriately such that the Career num from sheet 2 will fill in to each in between tasks two and ten,000 I've hooked http://rivonirecruitment.co.za/?p=34287