i have a document where i update hours for a machine. in one worksheet i update the machine hours at its last service. I want to know if it is possible to set up a formula so that this reading is linked to another worksheet and updates BUT then the next time i change the data in the cell from the first worksheet i want it to update in another cell in the 2nd worksheet, HOWEVER i want the previous cell to keep the hours from the previous service...
is this making sense to anybody?..

Please help!