Thanks! Most, but not necessarily all, of my panels have no spaces. But I'm
sure this alteration will save a couple of hairs in the future!
"Max" wrote:
Suggest a slight refinement to Gary's:
=INDIRECT(A1 & "!" & "$L$52")
ie use it like this:
=INDIRECT("'"& A1 & "'!L52")
The concat of the single apostrophes before and after the sheetname will
make it work even if the sheetname were to contain spaces, eg: P 1, instead
of P1.
The other simplification is a minor one where we can drop the $ signs for
the L52 and just meld it with the ! since the cell ref here is just a
textstring, it won't change.
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---