Question: how to transfer data from one sheet to another in excel using formula?
Answer: A. To transfer data, enter them in sheet 1, go to sheet 2 and the cell in which you want the linked number to appear and enter the equal ( = ) sign. Then go back to sheet 1 and the source cell and press Enter. Now, to transfer a formula: Assume the formula is in sheet 1, cell A1.