Excel formula for copying data from one sheet to another

Closed
Mia15 - Updated on Dec 4, 2018 at 07:10 AM
Ratnendra Ashok Posts 598 Registration date Wednesday November 28, 2018 Status Member Last seen June 4, 2020   - Dec 4, 2018 at 07:09 AM
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

1 response

Ratnendra Ashok Posts 598 Registration date Wednesday November 28, 2018 Status Member Last seen June 4, 2020   4,418
Dec 4, 2018 at 07:09 AM
Hi,

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! 

Thanks 
1