Menu
Ask a question Report

Excel formula for copying data from one sheet to another

-
Excel Ask a question Report
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 

1 reply

Best answer
Report Respond to Ratnendra Ashok
Posts
625
Registration date
Wednesday November 28, 2018
Status
Administrator
Last seen
October 14, 2019
 1705
1
Thank you
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 
Ratnendra Ashok

Community Manager - CCM.net

Respond to Ratnendra Ashok
Reply Ask a question