Copy last row with data from one sheet to another sheet

[danielfr]

Hi,

I know how to copy a row from one sheet to another sheet

But I don't know how to copy the last row with data from one sheet
to another sheet and to add it behind the last row with data . Or eventually to copy the active row from sheet 1 to another sheet and to add it behind the last row with data

Thank you for your help,

Daniel

[rollis13]

Copy this macro in a vbe module and give it a try. Adjust sheet names and be sure that destination sheet has row 1 compiled (titles or whatever):

Please Login or Register  to view this content.

[danielfr]

Hi Rollis,

Thank you for your help.

I checked with a Msg Box: the last row is correct
but I can't copy it because I am receiving the error message :" suscript out of range"

[danielfr]

I found it like this

Please Login or Register  to view this content.

[rollis13]

As said, did you adjust sheet names and/or check to have data in row 1 of destination sheet ?

[danielfr]

Yes I have data in row 1 but not in A1

[rollis13]

The test is on column A so you need to adjust the ranges in the macro.

[danielfr]

Thank you Rollis

[rollis13]

Glad having been of some help .