Jonayed
How to link data in Excel from one sheet to another is much required nowadays. In this scholarly, we are going to show you three quick approaches which will make linking data in Excel from one sheet to another easier. Moreover, you will get some examples of linking data in Excel at the end of this article.
📁 Download Excel File
You can download the free workbook from here:
Link Data in Excel from One Sheet to Another with 3 Quick Approaches
We’ve considered a dataset that contains approximately 10 columns and 5 rows. In this dataset, we added Product, SKU, Price, and Quantity to make you understand better. But if you want you can change the entities and put the values of your own.
1. Adopting Paste Link Preference to Link a Worksheet Cell with Another
The 1st approach, we are going to show you, is Adopting the Paste Link Preference to Link a Worksheet Cell with Another. There are some procedures given below to follow this approach.
⬇️⬇️ STEPS ⬇️⬇️
- First, go to the Dataset worksheet.
- Select the entire Quantity column (G4 to G10) and then Right-Click on the mouse.
- After that click on the Copy option in the context menu.
Now go to the Paste Link and then,
- Select the first cell of the Quantity column (F5) and Right-Click on the mouse.
- Then click on the Paste-Link option from the context menu.
- Now, if you have to select the whole column (F5 to F10), and press Enter thus the entire values will be copied.
- In the below screenshot, we are seeing that Cell F5 in worksheet “Paste Link” has become linked with the cell G5 in worksheet “Dataset”.
2. Transferring Data from One Excel Worksheet to Another Automatically Using Equal (=) Sign
In this 2nd approach, we are going to show you the method of transferring data from one Excel worksheet to another automatically using the Equal sign. Basically, there are two ways to follow this approach.
2.1 Manually Writing Cell Reference
The 1st way is manually writing the cell reference method. Follow the steps below to pursue this approach:
⬇️⬇️ STEPS ⬇️⬇️
- At first, go to the using sheet named “Equal” and select F5 cell.
- Then write the following formula and press Enter.
- Finally, select cell F5 and you will see a Plus icon appear at the lower right corner of the cell. This icon is known as the Fill Handle icon.
- Now, drag the Fill Handle Icon to fill up the whole column, and you will get the values.
- As a result, the cell range of F5:F10 has become linked with the Dataset worksheet. This is how you can link the data from one worksheet to another.
2.2 By Selecting Cells from Another Sheet
Here, we will select cells directly from the worksheet without writing any cell references. There are certain steps to follow this procedure that is given below:
⬇️⬇️ STEPS ⬇️⬇️
- Firstly, go to the using equal sheet.
- Select cell F5 and insert the Equal sign.
- Then go to the Dataset sheet.
- Now select cell G5 on the Dataset sheet and press Enter.
- Then you will get the result for cell F5.
- Finally, use Fill Handle Icon to swell the entire column, and you will get your desired results.
- The whole column will be filled with pertinent values.
Things to Be Noted:
In order to link one worksheet to another in Excel, you basically need to know the sheet’s name as well as the cell’s name.
Suppose, you have a sheet named “Fruit” and you require particulars from “C4”. You need to enter “=Fruit!C4” in any cell and consequently you will get particulars from your new sheet.
If you want it in an easier way, just type “=” in that cell, go to the other sheet, select your desired cell, and tap enter. You will get the required function.
Again if you need to change data in the basic “C4” cell in the “Fruit” sheet, the data will be updated wherever you referenced the cell.
3. Assigning Plus (+) Sign for Linking Data
This approach is one of the quickest ways to link data in Excel from one worksheet to another.
⬇️⬇️ STEPS ⬇️⬇️
- Firstly, you need to go to the Assigning Plus Note sheet.
- Then select cell F5 and insert Plus (+) sign in cell F5.
- After that go to the Dataset sheet.
- When you enter on the Dataset sheet, select cells G5 to G10 and tap Enter.
- Finally, you will get the proper relevant products.
Examples of Linking Data in Excel from One Sheet to Another
We have tried to add some examples of linking data in excel from one sheet to another so you can easily understand and think in deep about the topic.
1. Linking Multiple Cells From Another Sheet in Excel Based on Condition
In this procedure, we will learn the technique of linking multiple cells from another sheet in Excel based on the condition.
⬇️⬇️ STEPS ⬇️⬇️
- In the beginning, go to the Condition sheet.
- Select the G5 cell and put in the following formula.
- Now tap Enter and copy this creed to the cells (G5 to G10) utilizing Fill Handle Icon.
- Finally, you will get the desired values based on that condition.
2. Pulling Data from Another Sheet and Sum in Excel
This is another method to pull data from another sheet and sum in Excel.
⬇️⬇️ STEPS ⬇️⬇️
- Like before, go to the “Using the SUM Function” sheet
- Select cell C5 and put the following formula using the SUM function in Excel.
- Then go to the Dataset sheet, select the cells from G5 to G10 and tap Enter.
- Lastly, this will link the data and adjust the total values using the SUM function sheet.
How to Link Sheets in Excel to a Master Sheet
In this last section, we will show you how to link sheets in Excel to a master sheet.
⬇️⬇️ STEPS ⬇️⬇️
- First, go to the Linking Master Sheet.
- Select the desired cell (we took cell B5) and Right-Click.
- Then click on the Link option and again click on the Insert Link option.
- Now, click on the Place in This Document option in the new window.
- Then select VBA at cell reference and then click the OK button.
- Assuredly, this will create a link to the master sheet.
- Finally, if you click on that link, it will take you to the desired sheet.
📝 Takeaways from This Article
If we summarize the whole article we basically have got 3 approaches to link data in Excel from one sheet to another,
📌 In Approach 1, we’ve used the Paste Link preference where we copied all the data from the dataset and pasted them by using the Paste Link option from Right-Click.
📌 In Approach 2, we’ve transferred data from one sheet to another in Excel by using the Equal(=) sign. Here we applied 2 methods-
1. By writing cell references manually
2. By selecting a cell from another sheet
📌 In Approach 3, we used a Plus(+) note for linking data where we inserted a Plus(+) note on a particular cell and got the desired values by tapping Enter after selecting the required cells from the dataset.
We have also tried to show two examples of linking data in Excel from one sheet to another. Finally, we have shown the procedure of linking data in Excel to a master sheet.
Conclusion
We wish that you would be able to link data in Excel from one sheet to another using this article. As several methods have been shown here, you can easily follow which one is best suited for you. If there is any skepticism in your mind, feel free to ask me in the comment. In the end, to learn more about Excel tactics, we recommend you to visit our website ExcelDen.com.
