J
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
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