"Kim" wrote:
I am trying to list from 100s of sheets a number
so I go to lets say F10 on sheet 2 (sheet2!f10), (sheet3!f10),
(sheet4!f10).
How can I drag and copy so sheets change?
One way ..
Put in say, Sheet1's B2:
=INDIRECT("'Sheet"&COLUMN(A1)+1&"'!F10")
copy B2 across
B2, C2, ... will return the contents of: Sheet2!F10, Sheet3!F10, ...
And if we want to increment it for copying down instead of across,
just change COLUMN to ROW, i.e. use:
=INDIRECT("'Sheet"&ROW(A1)+1&"'!F10")
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---