Hi,
I have a two-part question.
I am trying to produce a summary workbook that accesses data from 100+ closed workbooks.
Previously I used indirect.exe but I can’t find a working version of morefunc online anymore.
I can access closed workbooks with this function :
='C:\Documents and Settings\o\My Documents\[WEEK90A.xls]Monday'!A1
So question one would be: How can I edit this function to make “WEEK90A.xls”, “Monday” and “A1” refer to indirect values held in a helper sheet called “workings”?
Eg workings!a1 contains the text “Week90”
workings!b1 contains the text “Monday”
workings!c1 contains the text “A1”
Question number two would be: Does anyone have a working version of morefunc they could put on the site as an attachment?
Thanks in advance
Bookmarks