Copy most current data row into another sheet

Hi,

i am trying to create a macro that will copy the most recent row of data into another sheet, and it should overwrite that sheets row:

exampe

Sheet A:

1 2 3
a b c
d e f
g h i




Sheet B:
1 2 3
g h i




so basically if i create a new row in sheet A (example: j k l). and run this macro, i want it to delete the row containing g h i in sheet B and replace it with the newest row (or bottom row) that i create in sheet A (in the example, j k l).

im kind of not even sure where to start.

Originally Posted by JBeaucaire

Assuming,

1) The last row on Sheet1 with data in column A is the row desired
2) The target row on Sheet2 is row 1.

Please Login or Register  to view this content.

Worked beautifully, i just modified the range("A1") to A2 because i wanted it to replace the 2nd row on sheet 2 becuase there are headers on row 1.

Thanks!!