Linking Daily Workbooks

G

General Specific

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?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Lookup cell next to data 2
VBA works in orignal but fails in copy of database 1
Set up and printing a 4-up mail merged postcard 0
Slideshow with black border around it 0
Command Button to create a folder 0
Dumb question alert! What program to use? 0
I want to tally my sheet 6
3 variable data in MS project file 0

Top