How to Link Data in Excel from One Sheet to Another (5 Methods)

Dataset Overview

In this tutorial, we’ll explore five methods for linking data between Excel sheets. We’ll use a concise dataset with approximately 6 rows and 2 columns. Initially, we’ve formatted all the cells containing dollar values in Accounting format, but you can adapt these methods for other data enters like currency, percentage, and time with minor adjustments.

Method 1 – Using Equal Sign

Open the sheet named Equal2.
In cell C5, enter an equal sign (=) but do not press Enter.

Switch to the sheet named Equal1.
Select the cells from C5 to C10.

Press Enter to link the data from Equal1 to Equal2.

Method 2 – Applying Plus Symbol

Go to the sheet named Plus2.
Enter a plus symbol (+) in cell C5.

Navigate to the sheet named Plus1.
Select the cells from C5 to C10.
Press Enter to link the Sales column as in the previous method.

Method 3 – Using the Paste Link Option

Open the sheet named Paste Link1.
Copy the cells from C5 to C10.

Switch to the sheet named Paste Link2.
Right-click on cell C5.
From the Paste Options, select Paste Link to create an immediate data link from the previous sheet.

Method 4 – Applying SUM Function

Click on the sheet named SUM2.
Insert the following formula in cell C10:

=SUM(

Go to the sheet named SUM1.
Select the cells from C5 to C9.

Press Enter to link the data between the two sheets and calculate the Total value in sheet SUM2.

Method 5 – Linking Data from One Sheet to Another Based on a Condition

In this method, we’ll explore how to link data from one sheet to another in Excel using conditions instead of a direct connection.

Open the sheet named Condition2.
Enter the following formula inside cell C5:

=IF(Condition1!C5>=1000,Condition1!C5,"")

Press Enter and then copy this formula to the cells below using the Fill Handle.
You should see that this formula links the data of the two sheets based on the given conditions.

How to Transfer Data from One Excel Worksheet to Another Automatically

If you want to transfer data from one Excel worksheet to another automatically, VBA (Visual Basic for Applications) is the best option. Here’s how to use it:

Go to the Developer tab and select Visual Basic.

Click on Insert in the VBA window and choose Module.

Enter the following VBA code in the new window:

Option Explicit
Sub Automatic_Transfer()
Dim Smartphone As String, Price As String
Worksheets("VBA1").Select
Smartphone = Range("B5")
Price = Range("C5")
Worksheets("VBA2").Select
Worksheets("VBA2").Range("B4").Select
If Worksheets("VBA2").Range("B4").Offset(1, 0) <> "" Then
Worksheets("VBA2").Range("B4").End(xlDown).Select
End If
ActiveCell.Offset(1, 0).Select
ActiveCell.Value = Smartphone
ActiveCell.Offset(0, 1).Select
ActiveCell.Value = Price
Worksheets("VBA1").Select
Worksheets("VBA1").Range("B5:C5").ClearContents
End Sub