Morefunc Excel 2013

[janko23]

Hi!

I am looking for INDEIRECT.EXT in MoreFunc ADD-IN but I cannot find it on web.

Does anybody know if this exists at all?

Or maybe somebody has better solution for:

Call specified cell (for example A1) from 50 sheets in file1 and collect al the values of sells A1 in other file in one column.


Thanks.
Jan

[ragulduy]

Can you not do something like:
=Sum([Book1.xls]Sheet1:Sheet50!A1)

Changing the filename and sheets names as appropriate?