Copper Contributor

I have used Excel for years but only in a simple way.  Now I am trying to import data from one sheet to another and have it automatically update on the second sheet when it chan

4 Replies
Hi! Seems like you need to keep updated the second sheet based on changes in the fisrt one? That's right? Could you please upload an example of your sheets?


Here is a step-by-step guide with a sample formula:

  1. Open your Excel workbook and navigate to the sheet where you want to import the data (the second sheet).
  2. Select the cell where you want the imported data to appear. Let us say you want to import data from cell A1 in the first sheet to cell B2 in the second sheet.
  3. In the formula bar at the top of the Excel window, type an equal sign (=) to start entering a formula.
  4. Switch to the first sheet (the one with the original data) by clicking on its tab at the bottom of the Excel window.
  5. Select the cell or range of cells that you want to import to the second sheet. In this example, select cell A1.
  6. Press Enter to confirm the formula. The data from the selected cell on the first sheet will now appear in the cell you selected on the second sheet.

The sample formula you would enter in cell B2 of the second sheet is: =Sheet1!A1

Whenever the value in cell A1 changes in the first sheet, the value in B2 of the second sheet will automatically update to reflect the new value.

You can extend this formula to import data from multiple cells by selecting a range of cells on the first sheet. For example, if you want to import a range of cells A1 to A5 from the first sheet to cells B2 to B6 in the second sheet, you would enter the formula: =Sheet1!A1:A5

By using this approach, any changes made in the first sheet will be automatically reflected in the second sheet based on the defined cell references in the formula.

Remember to save your Excel workbook after setting up the formula.

The text was created with the help of AI.

Thank you very much.  That is perfect.@NikolinoDE