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

Ratings:
0 Comment(s)
1912  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.

Other work sheet as below

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.

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

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

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