articles

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

Creating a Reference to another Sheet or Workbook

AVADHESH PATEL3436 26-Mar-2013

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


Updated 07-Sep-2019
Avadhesh Kumar Patel District Project Manager - Aligarh 14 months work experience in Panchayati Raj Department Sector as District Project Manager & 12 months work experience in IT Sector as Software Engineer. :-)

Leave Comment

Comments

Liked By