Excel formula for copying data from one sheet to another [Closed]

Report
-
Posts
601
Registration date
Wednesday November 28, 2018
Status
Member
Last seen
June 4, 2020
-
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 reply

Posts
601
Registration date
Wednesday November 28, 2018
Status
Member
Last seen
June 4, 2020
3,963
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
Thank you
Ratnendra Ashok

Community Manager - CCM.net

Subscribe To Our Newsletter!

The Best of CCM in Your Inbox

Subscribe To Our Newsletter!