Macro to move cells throughout spreadsheet

[Mel120585]

Hi everyone!

I hope someone can help, I am terrible at macros but would like to learn if possible!

I have a relatively large spreadsheet that I need to do two things to:

1) move every second cell in one row to the second row down in the previous column
2) delete every second column

I appreciate the second might be relatively easy to do but with over 12,000 columns of data it would be preferable to automate the process!

Please do let me know if this doesn't make sense and hope someone tasks pity on me

Thanks

Mel

 

[Mel120585]

Did you get to see Message #8 yet?

Hi Rick,

I have just tried it and it worked perfectly, thank you!

Thank you all for all your help, I can't claim to have understood all of the lines of code but I appreciate the outcome.

Thank you all,

Mel