1️⃣ Start on Your Main Sheet
- Open Sheet1 where you want the linked data.
- Click the cell where you want the link.
🔍 (An arrow pointing to a cell on Sheet1 with text: “Click here to start”)
2️⃣ Type an Equals Sign (=)
- Type
=in the cell. This starts a formula.
🔍 (A cell with an = showing a blinking cursor)
3️⃣ Go to the Other Sheet
- Click on Sheet2 where the source data is.
🔍 (An arrow from Sheet1 to Sheet2 with text: “Switch to Sheet2”)
4️⃣ Select the Cell You Want to Link
- Click the specific cell on Sheet2. For example, A1.
- You’ll see something like
=Sheet2!A1appear in the formula bar.
🔍 (Sheet2 showing a highlighted cell “A1” and a formula =Sheet2!A1 in the formula bar)
5️⃣ Press Enter
- Hit Enter to finish linking. Now, the data from Sheet2 will show on Sheet1!
🔍 (Sheet1 with the linked data displaying in the chosen cell)
📌 Extra Tip:
If you want to edit or update the link, just click the cell and modify the formula, e.g., change =Sheet2!A1 to =Sheet2!B2.