Excel复制/粘贴在同一张纸上

I would like to create a macro that will copy the last column of data, paste that value over itself and then paste the formula into the next empty column. I would like to create a macro that will copy t