Excel formula for copying data from one sheet to another

Hello, I have 10 columns and 142 rows of name of person and their details, Is it possible when I edit data from the first sheet, it will automatically be recorded to the other sheet. Example when I edit one of the rows in any columns of the persons details it will automatically copy to the next sheet, it will make a LIST of the names of my recent edits. with date and time of edit.
System Configuration: Windows / Chrome 70.0.3538.110
See more 

Your reply

1 reply

Best answer
Registration date
Wednesday November 28, 2018
Verified expert
Last seen
April 11, 2019
Thank you

It is possible to transfer data between two sheets by using a few simple formulas. Two of such formulas are described step-by-step here on this link.

Please revert in case of any query! 

Ratnendra Ashok

Community Manager - CCM.net

Respond to Ratnendra Ashok