Nonetheless Another element I'm battling to accomplish once the mass copy and paste has run I want One more code which will update column A accordingly this sort of that the Career num from sheet 2 will fill in to each between responsibilities 2 and 10,000 I have attached the http://mtthub.org/groups/new-step-by-step-map-for-mass-copy-lodz/