Wednesday 1 May 2013

Multiple Sheet Referencing in Microsoft Excel:

We can use (refer) cell of one sheet in any calculation on another sheet. For this we just have to use following syntax:

Sheet_name!cell_name
If we have changed the sheet name (sheet rename) then we must use that name. The picture is showing total of A1 cell of sheet1(value:10), Sheet2(value:20), Sheet3(value:30) on 4th Sheet.

By -
Labels:

No comments:

Post a Comment

Subscribe to: Post Comments (Atom)
  • Recruitment Yield Pyramid:
    Recruitment Yield Pyramid: Ø   To calculate the number of applicants they must generate to hire the required number of employees. Ø   T...
  • Job Designing
    Job Design : Involves conscious effort to organize tasks, duties and responsibilities into a unit of wok to achieve certain object.   Job d...
  • PRINCIPLES OF WAGES AND SALARY ADMINISTRATION
    PRINCIPLES OF WAGES AND SALARY ADMINISTRATION The generally accepted principles governing the fixation of wages and salary are: (i) Ther...