Lookup a sheet via a cell's data

M

MACRE0

I have a 'Total' Sheet and sheets A thru Z. I would like all of the
totals in the same positioned cells of A:Z individually lookedup and
placed in the 'Total' sheet (ie. ='a'!G45+'b'!G45 ...). Those cells
would then be totaled. Because there are quite a few sheets, and all
the columns in the 'Total' sheet are alike, I'd like to have each
respective row reference a cell in that row. That cell would contain
the sheet name (just 'a' for instance).


a ='a'!G45 ='a'H45
b ='b'!G45 ='b'H45
...
z ='z'!G45 ='z'H45


where instead of the manually imputed sheet letters I'd like it to be
found via the cell on the left.

a ='a1'!G45 doesn't work (assuming that "a" was in cell a1)

Thanks.
 
M

MACRE0

That's wonderful Frank, Thanks.

Is the Indirect Function primarily used for looking in sheets, files
folders and things of that nature? Just curious what else I could us
it for. I will research it some on my own. Thanks again.

MACR
 
F

Frank Kabel

Hi
INDIRECT is used to create cell/range references from a text string
value. So if you have a reference somethere stored as text you can use
INDIRECT to convert this to a range reference.

Note: INDIRECT does NOT work on closed workbooks!
 
Top