Do You Know by GURUS
Excel Functions
Consolidation
=INDIRECT("'[SECOND_FILE.XLS]"&MID(CELL("filename",$A$1),FIND("]",CELL("filename",$A$1))+1,256)&"'!$"&SUBSTITUTE(ADDRESS(1,COLUMN(),4),"1","")&ROW())
No comments:
Post a Comment
Newer Post
Older Post
Home
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment