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.