Home > DeveloperSection > Articles > Creating a Reference to another Sheet or Workbook

Creating a Reference to another Sheet or Workbook


Excel Excel 
Ratings:
0 Comment(s)
 1632  View(s)
Rate this:

Creating a Reference to another Sheet or Workbook

Excel sheet provide one most important feature to set reference with another sheet or workbook. You use external references when working with large amounts of data or complex formulas that are spread across several workbooks.

For demonstration first create work sheet as below. I have created five work sheets with different values for better understanding.

Creating a Reference to another Sheet or Workbook

Other work sheet as below

Creating a Reference to another Sheet or Workbook

Creating a Reference to another Sheet or Workbook

Creating a Reference to another Sheet or Workbook

Now, I’m going to calculate total expenses of sheet “US”, ”India”, ”Japan” on “Total” sheet. Steps are given below

Step 1: Select Cell of “Total” sheet where you display sum of values and write “=” sign as below image.

Creating a Reference to another Sheet or Workbook

Step 2: Now open “US” sheet and select or write cell index which you want sum with another sheet’s cell value. See below image

Creating a Reference to another Sheet or Workbook

Step 3: Now enter “+” sing then select “India” and “Japan” sheet and enter cell index as below image

Creating a Reference to another Sheet or Workbook

Now press enter key and see output on “Total” sheet as below image.

Creating a Reference to another Sheet or Workbook


Don't want to miss updates? Please click the below button!

Follow MindStick