Hello
I want to transfer data in the last colom of a worksheet to another worksheet.
After that I want to delete that last row, and then transfer the data from the new last row into the other worksheet.
example:
When the last row with data is K, then I want to copy K5 to a cell in another sheet. But when the last row with data is P, then I want to copy P5 to that other sheet. After the copying, the data of the last should be deleted.
So, initially the last row was K, but after copyying the data, and then deleting K, the last row becomes J.
Can anybody help me with this?
Thanks.
Kir
I want to transfer data in the last colom of a worksheet to another worksheet.
After that I want to delete that last row, and then transfer the data from the new last row into the other worksheet.
example:
When the last row with data is K, then I want to copy K5 to a cell in another sheet. But when the last row with data is P, then I want to copy P5 to that other sheet. After the copying, the data of the last should be deleted.
So, initially the last row was K, but after copyying the data, and then deleting K, the last row becomes J.
Can anybody help me with this?
Thanks.
Kir