Help with multi sheet referencing

  • Thread starter Thread starter Charles
  • Start date Start date
C

Charles

I am a noob at Excel so a appreciate your patience.

I have a multisheet workbook. the first sheet is to be a summary of the
other sheets (containing totals and names form the other sheets). I have
three questions.

1. How do reference the name of the sheet in one of the sheet's cells? (For
example, on sheet1 I want C1 to carry the sheets name "Sheet1" and for it to
change if the sheet is renamed

2. On the summary sheet I want to list in a cell whatever the name of sheet1
is, by looking at the C1 cell from question 1

3. Sheet1 1 has a calulated total on it, I want to copy that calulated total
onto the summary cpage without recalculating it each time


I greatly appreciate any help you can provide


CL
 
Charles

1. =MID(CELL("Filename",A1),FIND("]",CELL("Filename",A1))+1,255)

2. =Sheet1!C1

3. =Sheet1!cellref where cellref contains the Total

Note: when you change the name of Sheet1 all formulas will update.


Gord Dibben Excel MVP
 
Back
Top