Having Said that the following aspect I am having difficulties to do once the mass copy and paste has run I would like another code which will update column A appropriately this kind of which the Career num from sheet two will fill in to each in between duties two https://mass-copy-print-egmore04704.p2blogs.com/38192997/the-ultimate-guide-to-mass-copy-in-excel