Nevertheless Another element I'm struggling to carry out after the mass copy and paste has run I would like Yet another code that will update column A accordingly these that the Career num from sheet two will fill in to each between jobs 2 and ten,000 I have hooked up http://mtthub.org/groups/copy-message-can-be-fun-for-anyone-1617689097/