Sorry its hard for me to explain so I included a picture. I want to copy all the data in entire rows 8 thru 15 then paste it as new rows in rows 32 thru 39. Then I want to just change the highlighted 14 to a 17 on my newly created rows but I want to keep the existing 14 as it is. I'm sure this is super simple, I'm just not good at excel yet. My initial research showed to use replace but that would delete the 14 which I dont want to do. Thanks for your help, hopefully this is a softball question.