Hi There,

I got a Table with 2 column. 1st column Label as Desk, and 2nd column label as Asset. What I like to do is that, when I key in the data into the Desk cell and Asset cell, when it goto the second row, it will automatically copy the last value from desk column

Example: Assuming this is the table:

Desk | Asset
----------------------------
Desk01 | Asset01 "Once I press Tab, it will goto the next row, Then it copy the last record which is "Desk01" down.
Desk01 | Asset02


Please advise how to do that in VBA.

Thanks