Hi I have workbooks which are numbered numerically 1-600 am trying to use a cell in a different workbook which will reference on of those 600 workbooks and bring data from each one individualy.
I have been tring to use this formula but I think its not allowing me to add the .xls please help.
=INDIRECT("\\gammanas\gamma\Job Cost\Gamma\GAMMA 2015\JOB COST\"&E18".xls"&"!C38")