Скачать или смотреть How To Reference Cell or Pull Data from Another Worksheet

How To Reference Cell or Pull Data from Another Worksheet?
Whenever you create dashboards or cross-sheet calculations you'll need to pull data from another worksheet. In this excel tutorial i will show you ways to run cross sheet calculations and also how you can pull data from another worksheet. This tutorial is demonstrated on Microsoft excel 2019. Lets get started.

Method 1:

Referencing a Single Cell:
Referencing a sheet requires writing the sheet name followed by an exclamatory sign (!) after that you'll have to write the cell no/name. All of this begins with a = sign.
Example: =Sheet2!A1 This will pull the value from cell A1 within Sheet 2 and place the data where you've written the formula.

Referencing a Single cell From a Sheet Name with Spaces and Different Characters:
Suppose your sheet name has spaces or different characters then you'll have to add single quote ( ' ' ) to your sheet name and everything will be the same.
Example: ='Custom Name'!A1 This will pull the value from cell A1 within Sheet Custom Name and place the data where you've written the formula.

Cross Sheet Calculation:
Suppose you want to sum values from Sheet 2 and Place the results in Sheet 1. You'll have to write =Sum(Sheet2!A1:A5) Now this formula will sum up values from cell A1 to Cell A5 from sheet 2 and place the results where you put the formula. Now if you have spaces within your worksheet name you'll have to add Single Quote (' ') to your worksheet name and the rest remains the same.

Method 2:

Referencing a Single Cell:
Referencing a sheet requires writing = and the Click on the sheet name on the sheet tab and after that click on the cell no and press enter.
Example: Write = and click on the Sheet 2 and then click on the cell A1. This will pull the value from cell A1 within Sheet 2 and place the data where you've written the formula.

Cross Sheet Calculation:
Suppose you want to sum values from Sheet 2 and Place the results in Sheet 1. You'll have to write =Sum( Now click on the Sheet 2 from the sheet tab and select cell A1 to Cell A5 now close parenthesis and press enter. Now this formula will sum up values from cell A1 to Cell A5 from sheet 2 and place the results where you put the formula.

This is how you can pull data from different worksheets or do cross sheet calculations.

#CellReference #PullValue
Thanks for watching.
-------------------------------------------------------------------------------------------------------------
Support the channel with as low as $5
  / excel10tutorial  
-------------------------------------------------------------------------------------------------------------
Please subscribe to #excel10tutorial
https://goo.gl/uL8fqQ

Here goes the most recent video of the channel: http://bit.ly/2oXmqsb

Playlists:
Advance Excel Tutorial: https://goo.gl/ExYy7v
Excel Tutorial for Beginners: https://goo.gl/UDrDcA
Excel Case: https://goo.gl/xiP3tv
Excel VBA Programming Course: http://bit.ly/excelvbacourse

Social media:
Facebook:   / excel10tutorial  
Twitter:   / excel10tutorial  
Blogger: https://excel10tutorial.blogspot.com
Tumblr:   / excel10tutorial  
Instagram:   / excel_10_tutorial  
Hubpages: https://hubpages.com/@excel10tutorial Become a member and enjoy exclusive perks while supporting the channel you love!
   / @excel10tutorial