One way:
Enter in A5:
=INDIRECT("Sheet"&ROW(A1)&"!A10")
And copy down as needed.
--
HTH,
RD
---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
"asubramaniam" wrote in message
...
I have a workbook containing several sheets , all of which use identical
formats - 12 sheets, one for each month of the year.
I want a summary sheet with the values of the same cell address in each
sheet
For example, Summary!A5 = Sheet1!A10
A6 = Sheet2!A10 and so on
Is there an inbuilt Excel function or simple way to do this.
--
AS
|