Graphed LogoGraphed
Graphed LogoGraphed
How It WorksAgentsIntegrationsPricing

How to Link Data Between Sheets in Excel

Cody Schneider••6 min read

Tired of manually copying and pasting the same sales total from one Excel sheet to another a dozen times? There’s a much smarter, error-proof way to work. This guide will show you several methods to link data between sheets in Excel, from simple cell references to more powerful techniques that help you create dynamic reports.

GraphedGraphed

Your AI Data Analyst to Create Live Dashboards

Connect your data sources and let AI build beautiful, real-time dashboards for you in seconds.

Watch Graphed demo video

Why Bother Linking Data Between Excel Sheets?

Before jumping into the "how," let's quickly cover the "why." Linking data isn't just a neat trick, it's a fundamental practice for building reliable and efficient spreadsheets. The core benefits include:

  • Consistency: When your master data is in one place, you only have to update it once. Every linked cell or chart across your entire workbook will update automatically, ensuring everyone is looking at the same information.
  • Accuracy: Every time you manually copy and paste, you risk making a mistake. You might paste into the wrong cell, copy the old data, or make a typo. Linking eliminates this human error.
  • Efficiency: Stop wasting time on repetitive data entry. Linking automates the process of pulling summary numbers, product details, or sales information into different reports or dashboards, freeing you up to focus on analysis rather than data wrangling.
  • Organization: A well-structured workbook often separates raw data from summaries and reports. Keeping your raw sales figures on one sheet and your high-level dashboard on another makes your file cleaner and easier for others to understand. Linking is the connection that makes this structure possible.

Method 1: The Simple Cell Reference (Formula Linking)

This is the most common and direct way to link a single cell or a range of cells from one sheet to another. It’s perfect for pulling a specific value, like a grand total or a key metric, into a summary sheet.

The syntax for a cross-sheet reference is straightforward:

='SheetName'!CellAddress

Let’s break it down:

  • The equals sign (=) tells Excel you're starting a formula.
  • The SheetName is the name of the sheet where your source data lives. If the sheet name contains spaces (e.g., "Q1 Sales"), you must enclose it in single quotes: 'Q1 Sales'.
  • The exclamation mark (!) is the character that tells Excel you are referencing a different sheet.
  • The CellAddress is the cell you want to pull data from (e.g., F15).

Free PDF Guide

AI for Data Analysis Crash Course

Learn how to get AI to do data analysis for you — the best tools, prompts, and workflows to go from raw data to insights without writing a single line of code.

Step-by-Step Example

Imagine you have a workbook with two sheets: "SalesData" and "Dashboard". The total Q1 sales amount is in cell F50 on the "SalesData" sheet, and you want to display this total on your "Dashboard".

  1. Go to your destination sheet, which is "Dashboard" in this case.
  2. Click on the cell where you want the linked data to appear (e.g., B2).
  3. Type the equals sign: =
  4. Without typing anything else, click on the tab for your source sheet ("SalesData").
  5. Click on the source cell (F50).
  6. The formula in the formula bar will be: =SalesData!F50
  7. Press Enter. Cell B2 will now display the value from F50 on the "SalesData" sheet.

That's it! Now, any time the value in F50 on "SalesData" changes, the value in B2 on "Dashboard" will update instantly.

Pro Tip: You can also link entire ranges. After creating your first link, click the small square in the bottom-right corner of the cell (the "fill handle") and drag it down or across to link adjacent cells from the source sheet.

Method 2: Looking Up Related Data with VLOOKUP and XLOOKUP

Simple cell linking is great for one-to-one connections, but what if you need to find a specific piece of information within a large table on another sheet? This is where lookup functions shine.

For example, you have a list of Order IDs on your main report sheet, and you need to pull in the corresponding Customer Name and Product from a massive "Order Details" sheet containing thousands of rows.

GraphedGraphed

Your AI Data Analyst to Create Live Dashboards

Connect your data sources and let AI build beautiful, real-time dashboards for you in seconds.

Watch Graphed demo video

Using the Classic VLOOKUP

VLOOKUP (Vertical Lookup) searches for a value in the first column of a table and returns a value in the same row from a column you specify.

Here’s the syntax:

=VLOOKUP(lookup_value, table_array, col_index_num, [range_lookup])

  • lookup_value: The value you're looking for (e.g., the Order ID in your report).
  • table_array: The range of data on your source sheet to search within.
  • col_index_num: The column number in the table_array from which to retrieve a value (e.g., 2 for the second column).
  • range_lookup: Use FALSE for an exact match.

Suppose your report is on "Summary" and your data table is on "Orders" in range A2:D5000. Order IDs are in column A, Customer Names are in column B.

The formula in your "Summary" sheet would be:

=VLOOKUP(A2, Orders!$A$2:$D$5000, 2, FALSE)

This tells Excel: "Look for the value in A2 (on this sheet). Search for it in the first column of Orders!A2:D5000. If found, return the value from the 2nd column."

Using the Modern XLOOKUP

If you're on a recent version of Excel (Microsoft 365 or Excel 2021), XLOOKUP is a far more flexible and powerful replacement.

Why XLOOKUP is an Upgrade:

  • It can look to the left (VLOOKUP only looks to the right).
  • It’s more intuitive, allowing separate selection of lookup and return arrays.
  • Defaults to exact match, so no need to specify FALSE.

The syntax:

=XLOOKUP(lookup_value, lookup_array, return_array)

Using the previous example:

=XLOOKUP(A2, Orders!$A$2:$A$5000, Orders!$B$2:$B$5000)

This searches A2 in the Order ID column (A2:A5000) and returns the corresponding Customer Name from B2:B5000.

Free PDF Guide

AI for Data Analysis Crash Course

Learn how to get AI to do data analysis for you — the best tools, prompts, and workflows to go from raw data to insights without writing a single line of code.

Method 3: Creating a Dynamic View with Linked Picture

Sometimes you don’t just want the data, you want a visual snapshot including formatting, charts, and layout from another sheet. This is perfect for dashboards. A Linked Picture is a live, dynamic screenshot of a range.

  1. Go to your source sheet and select the range you want to display (including charts/objects).
  2. Copy the range (Ctrl + C).
  3. Go to your destination sheet and click where you want the picture.
  4. In the Home tab, click the dropdown under Paste, then select As Picture > Paste Picture Link (or Paste Special > Linked Picture in older versions).

This creates a picture object. Any changes in the source range will instantly reflect in this picture, making it ideal for live dashboards.

Best Practices and Common Mistakes

As you start linking sheets, keep these tips in mind:

  • Sheet Names with Spaces: Wrap sheet names with spaces in single quotes, e.g., 'Monthly Report'!C5.
  • #REF! Error: Usually means a broken link—perhaps the source sheet or cell was deleted. Be cautious when restructuring.
  • Absolute vs. Relative References: To prevent ranges from shifting when copying formulas, use absolute references (e.g., $A$2:$D$5000). Press F4 after selecting the range to toggle.
  • Organize Your Sheets: Use clear, descriptive names for your sheets to make formulas easier to read and debug.

Final Thoughts

Mastering linking techniques makes your Excel spreadsheets more reliable, efficient, and easier to maintain. Whether you're using simple cell references, lookup functions, or dynamic snapshots, these tools will save you time and reduce errors.

Connecting data is the core of analytics, inside Excel or across platforms like Google Sheets, Google Analytics, Shopify, and CRMs. While Excel methods are powerful, managing dozens of VLOOKUPs or downloading CSVs weekly can be tedious. That’s why we built Graphed: to connect your sources securely and build real-time dashboards via simple questions in plain English. No complex links—just insights.

Learn more and get started with Graphed

Related Articles