Nevertheless another portion I'm having difficulties to accomplish following the mass copy and paste has run I would like another code that will update column A appropriately these kinds of that the Occupation num from sheet 2 will fill in to each between duties 2 and ten,000 I have hooked up the sheet and additional a last Answer sheet in the event that my explanation did not make sense you might see what I had been striving to accomplish. Click on to expand... in spite of the setback this vital livestock marketplace has obtained a result of the greater use of mechanised means for road transportation , india still possesses some useful inventory on the indigenous breeds that are effective at further more advancement and propagation . On Copy ’Em It can save you a number of lists, star favored merchandise, and generally keep the clipboard neat and tidy.