Need to copy data to next empty row in another tab

[BillDoor]

Hi

I need a macro that will copy data from a set of cells in one tab to another tab, but it need to look for the next available column first

e.g. copy cells (values only) C4:C10 from Sheet1 to the next free column on Sheet2 (starting at row 4)

Can anyone please help with this?

thanks guys!

(or if there's a way to do it without a macro...)

[p24leclerc]

try this macro

Please Login or Register  to view this content.

[BillDoor]

Hi

this isn't quite working, it's copying the formula rather than just the values and for some reason it's not putting it into Sheet2, it seems to be putting it into another tab I have in the sheet I'm using.
I tried renaming the tab and where it says sheet2 in the code and it's still putting it in the wrong (albeit a different) tab.

Can you help please?

thanks

[AB33]

Please Login or Register  to view this content.

[AB33]

If you want to copy down

Please Login or Register  to view this content.

[BillDoor]

thanks, that seems to work fine