vba for copy paste to blank cell

[Lazypanda]

Hi all,

I hope you can help me - I have searched the web but no luck

Right, what I need is a vba code that copies a range in a sheet and then paste it in the next available blank column.

Illustration:

A B C AB
1 8
9 7
6 4

What I need it to do is copy cells in column AB then paste it in column B then when B has data paste in Column C.

Note: all the data will be held in the same sheet.

Hope this makes sense.

Thanks for your help in advance

[Lazypanda]

*Numbers 8,7 and 4 should be below AB in the illustation.

[wamp]

Hi.
Save this code as a macro and run it.

Please Login or Register  to view this content.

note: always make backup of your spreadsheet before trying out new codes/macros.

[Lazypanda]

Hi Wamp,

Thanks for your help.

I have tried the code you suggested but it is not doing what I want. It copies column AB then paste it in AC and when I repeat it the action is the same.

I need it to copy column AB then paste it in the next availble blank column after column A as illustrated in my first post. I need to be able to repaeat this action multiple times.

Hope you can help.

[Lazypanda]

Please help

[wamp]

that's strange.
here's what the code is supposed to do..

Please Login or Register  to view this content.

so far so good.. this seemed to work.

Please Login or Register  to view this content.

it works flawlessly on my machine..
could you upload your excel file?

[Lazypanda]

The macro isn't working for me properly. I have attached my test file with the macro that i have been using.

It copies the data in AB into AC and and repeats the same action - it does not move to AD once AC has data.

I need it to start from column A then move across.

I appreciate you taking your time to help me.

[wamp]

Sorry for the late reply.

My code was based on there beeing something in column B.

here is the corrected code:

Please Login or Register  to view this content.