Copy data from one sheet across to empty row in next worksheet

Hi,

I need to copy data from one worksheet across to another worksheet in the same workbook, which is easy enough (I have used a macro to do this) but the problem I have is that everytime I run the macro, it copies the data across to the same row, therefore overwriting anything already existing in that row.

Could someone clever please let me know how I can set it to copy to the next empty row each time?

I can submit an example if necessary.

Thank you very much,

Jo

Hi Jo,

Try using this macro at the start:

Private Sub Workbook_SheetActivate(ByVal Sh As Object)


Regards,

Vivek

Hi,

Thank you very much for your replies. I'm probably being a bit thick, but I tried pasting the code into a new macro, but it didn't work.

I've attached a basic copy of the file so you can get the gist of what I'm trying to do.

Many thanks,

Jo

Wow! Thanks thameem127, that's brilliant.

Thank you so much again to all of you.

Jo

your welcome. Please press star available in left side of my post and mark this thread as solved.