Sheet!cell reference

D

Dennis Allen

Hi. Got a set of sheets, each with a unique id for a sheet name. Have a summary sheet which I have to create columns referencing
sheet information. As an example, in column C of my summary sheet one cell will have='10034'!B4. But column B of the summary sheet
already has the ID (numeric value 10034).

Question. Is there a way to grab the value in column B to use as a reference? I've tried =TEXT(B33,"#####")!B4, but that doesn't
work. Any help is appreciated...Dennis
 
F

Frank Kabel

Hi
try
=INDIRECT("'" & B33 & "'!B4")

--
Regards
Frank Kabel
Frankfurt, Germany

Dennis Allen said:
Hi. Got a set of sheets, each with a unique id for a sheet name.
Click to expand...
Have a summary sheet which I have to create columns referencing
sheet information. As an example, in column C of my summary sheet
Click to expand...
one cell will have='10034'!B4. But column B of the summary sheet
already has the ID (numeric value 10034).

Question. Is there a way to grab the value in column B to use as a
Click to expand...
reference? I've tried =TEXT(B33,"#####")!B4, but that doesn't
 
D

Dennis Allen

Thanks...Dennis

Frank Kabel said:
Hi
try
=INDIRECT("'" & B33 & "'!B4")

--
Regards
Frank Kabel
Frankfurt, Germany


Have a summary sheet which I have to create columns referencing
one cell will have='10034'!B4. But column B of the summary sheet
reference? I've tried =TEXT(B33,"#####")!B4, but that doesn't
Click to expand...
 
Top