Macro to add data to 'next available column' in excel

[perera3112]

Hi,

I think this is really simple to do but basically I would like to be able to create a macro where I can copy a set of cells from a worksheet and paste them in the next available column from the start of the worksheet.

So If column A already has data in it, the macro will see this and paste the copied cells into column B - going as far down in terms of rows as the number of cells copied.

I also then need to do this where it copies from one worksheet and pastes into another - but does exactly the same thing as above.

Any help would be greatly appreciated.

Thanks in advance for your help!

[watersev]

hi, perera2112, please check attachment, some options to make it, run code "test"

[perera3112]

hi, perera2112, please check attachment, some options to make it, run code "test"

Hi.

Thanks for this. I can see that this works - but am struggling to apply it to the automated macro which I have at the moment:

Please Login or Register  to view this content.

Everytime it does a 'paste-special' above - the macro should paste special to the next available cell going horizontally to the right. Thats the complicated bit.

[royUK]

Your post does not comply with Rule 3 of our Forum RULES. Use code tags around code. Posting code without them makes your code hard to read and difficult to be copied for testing. Highlight your code and click the # at the top of your post window. For more information about these and other tags, found here

[watersev]

Let's asume cells A1, B1, C1 hold some values, then this

Please Login or Register  to view this content.

will select next empty cell D1

[perera3112]

Excellent. Thanks very much for this!

[watersev]

if you are satisified with the offered help and there are no more outstanding issues regarding this thread, please mark the thread as solved (see Forum Rules on "How to" questions)