Macro to copy and paste relative columns

jaredly

New Member
Joined
Feb 16, 2019
Messages
1
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.
 

Some videos you may like

Excel Facts

Square and cube roots
The =SQRT(25) is a square root. For a cube root, use =125^(1/3). For a fourth root, use =625^(1/4).

JoeMo

MrExcel MVP
Joined
May 26, 2009
Messages
17,208
Office Version
  1. 365
  2. 2010
Platform
  1. Windows
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.
 

Watch MrExcel Video

Forum statistics

Threads
1,108,989
Messages
5,526,095
Members
409,685
Latest member
Bellybb

This Week's Hot Topics

Top