Sheet name in another sheet's cell

  • Thread starter Thread starter Khalil Handal
  • Start date Start date
K

Khalil Handal

Hi,
I have 12 sheets for 12 months
An other sheet is used for summary (sheet 13)
I need to copy range of cells (part of a column) from each sheet and put in
sheet 13.
sheet 13 does not contain the names of the 12 previous sheets.

Is there a way to tel the program:
to get value in cell C170 from sheet 1 and put it in cell D50 in sheet 13 in
a way that if i renamed one of the 12 sheets the sheet 13 will not be
affected.
Khalil
 
D50: =Sheet1!C170

If the sheet is renamed the formula updates.

--

HTH

RP
(remove nothere from the email address if mailing direct)
 
Back
Top