copying cells with a macro

I would like to copy a range of cells with a marcro, for example copying range C3:C15 over to D3:D15 and when I run the macro again I want range D3:D15 to copy to E3:E15 and from there to copy E3:E15 to F3:F15. I want to keep that going to the next and the next with the same macro. But it just keeps copying the the original range which I recorded in the macro, but I want it to keep going. If somebody can help me with that, I would sure appreciate hearing from you.
Thanks

Hello miketsch,

Welcome to the Forum!

A good starting point would be to see your recorded macro. To make your posts easier to read, copy, and edit please wrap your code.

How to wrap your Code
1. Select all your code using the mouse.
2. Click on the # icon on the toolbar in the Message window. This will automatically wrap the text you selected with the proper Code tags to create a Code Window in your post.

Use the Bulletin Board Code Tags
[code]Please [url=https://www.excelforum.com/login.php]Login or Register [/url] to view this content.[/code] at the end of the last line.


To learn more about BB codes used in this forum, just click on the link below...

Bulletin Board Codes Tags

I'm having a hard time visualising what you are trying to get out of this. I ran the recorded macro you provided and it copied the cells you wanted, but then placed a date a the top of that data and then removed the data. Only thing that was left was the data in Column R and a date at the top of column S.

Are you trying to shift data to the right so you can input new data? Are you retaining any data in the columns you are copying to? Are you trying to move a column of data to a spot of your liking (running over any data that might be in it's way)? Need a little more information plz.

Two words "Macro Recorder"

Instead of going through and copying everything to shift if over I went with a copy an insert. You aren't dealing with any merged cells so it's an easy shift.

Please Login or Register  to view this content.

This will keep your previous data and allow you to enter new data. If you like this solution please click on the scales to rate me, if this solves your issue then please select solved in your reply.

If my previous post didn't work with what you had in mind, then what difference would it need to make it work for you?

Are you only retaining a certain amount of data (A cutoff of how many columns you have)?

Let me know and I can adjust the code.