Copy and paste into next available column

[jimmisavage]

Hi all,
I'm looking for a macro to copy B2:L2 from sheet 2 into the available blank cell in row 'A' (or even better the one after that cell) in sheet 1.
I have found help to paste at the bottom of the worksheet but it's row 'A' that I need to paste into.

I would appreciate it if anyone can help me.

Many thanks
Jimmi

[AB33]

Please Login or Register  to view this content.

[alansidman]

Try this:

Please Login or Register  to view this content.

[jimmisavage]

Fantastic - Thanks very much AB33

[ARGK]

Hi Jimmi
Cut and paste this code into a module in your workbook and run it.

Please Login or Register  to view this content.

Hope it helps.
Good luck.
Tony