I receive daily workbooks from field crews. I would like to compile
daily billing one bi-weekly workbook. I want to link the bi-weekly
summary to the daily workbooks.

I have it working, but I need to automate the process so I can enter
the job name and the summary sheet updates the links.

A link might look like this:

='C:\Jobs\Job A - Invoice\[Labor - Job A - 9-16-08.xls]Summary'!$B$14

The job name is Job A
I have a directory called C:\Jobs\Job A - Invoice
In that directory are the data sheets. in this case Labor - Job A -
9-16-08.xls

Is there any way that I can put a named range or a variable in the
formula to allow me to change that link based on the heading info on
the current sheet?

So if I put in

Project: Job A
Date 9-17-08

the formulas would be updated on that sheet to reflect that day's data?

Hi General Specific

Maybe this is a option
http://www.rondebruin.nl/summary2.htm

--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm


"General Specific" wrote in message
...
I receive daily workbooks from field crews. I would like to compile
daily billing one bi-weekly workbook. I want to link the bi-weekly
summary to the daily workbooks.

I have it working, but I need to automate the process so I can enter
the job name and the summary sheet updates the links.

A link might look like this:

='C:\Jobs\Job A - Invoice\[Labor - Job A - 9-16-08.xls]Summary'!$B$14

The job name is Job A
I have a directory called C:\Jobs\Job A - Invoice
In that directory are the data sheets. in this case Labor - Job A -
9-16-08.xls

Is there any way that I can put a named range or a variable in the
formula to allow me to change that link based on the heading info on
the current sheet?

So if I put in

Project: Job A
Date 9-17-08

the formulas would be updated on that sheet to reflect that day's data?