Macro to copy and paste relative columns

[jaredly]

I currently have three column. I'd like to record a macro so that I can copy column C insert it into a new column, D, but the next time I run the macro copy D into E and so on. Currently the macro is "absolute" and always goes back to record column C. Thanks.

 

[JoeMo]

I currently have three column. I'd like to record a macro so that I can copy column C insert it into a new column, D, but the next time I run the macro copy D into E and so on. Currently the macro is "absolute" and always goes back to record column C. Thanks.

Post the macro and maybe someone here will help you modify it.