Question: how to copy data from one cell to another sheet in excel using formula?
Answer: Using Copy and Paste Link method Copy the cell value of 200 from cell A1 on Sheet1. Go to Sheet2, click in cell A1 and click on drop down arrow of Paste button on Home tab and select Paste Link button. It will generate a link by automatically entering formula =Sheet1! A1 .