external references, varying addresses within functions

[jeashe]

This is similar to Philip's post earlier.

I have many workbooks all in the same format and a roll-up workboo
which imports data from the other workbooks.

I put the workbook names in the left-hand column and want to write
single formula and vary the workbook names in it.

For example,
=SUM(g:\reports\[jetime.xls]Daily'C10:C25)
would be the final formula I want in the cell.

I am looking to vary the workbook address by the values in the lef
column (a jetime, a fktime, a ratime, etc.) so I can copy the formula
down and over and change names just by editing a single column

 

[Harlan Grove]

I am looking to vary the workbook address by the values in the left
column (a jetime, a fktime, a ratime, etc.) so I can copy the formulas
down and over and change names just by editing a single column.

See

http://google.com/[email protected]