I have two different excel documents. One is called "Job Costing" and the
other is the "Project Book". I update the Job Costing sheet daily, and then
I put the total from that sheet onto the Project Book when that particular
job is finished. It would be extremely helpful if the Project Book could
update automatically each time that I update the Job Costing sheet. However,
these two documents are on two different folders on our server, so I'm not
sure if that's possible. Is it?

Thanks so much!

Aaron

It should be provided you quote the full path name of the source Workbook.

For a simple example go to:-

http://www.pierrefondes.com/

Scroll down to item number 47 where you will find 2 Linked Workbooks.

If you pull these up on your screen (both at the same time) update cell A1
in avinity1.xlsx and you will see A1 in avinity2.xlsx update automatically.

Just examine A1 in avinity2.xlsx to see how the data is pulled from the
other Workbook.

In your situation you just need to make sure that the full path name of the
source file is quoted, for example, in cell A1 of avinity2.xlsx.

Please hit Yes if my comments have helped.

Thanks.



"Hoov" wrote:

I have two different excel documents. One is called "Job Costing" and the
other is the "Project Book". I update the Job Costing sheet daily, and then
I put the total from that sheet onto the Project Book when that particular
job is finished. It would be extremely helpful if the Project Book could
update automatically each time that I update the Job Costing sheet. However,
these two documents are on two different folders on our server, so I'm not
sure if that's possible. Is it?

Thanks so much!

Aaron

jo
yes it is.
open both workbooks, project book and job costling.
in project book, select the cell you want to update.
enter an equal sign (=) in that cell which should put you in edit mode
while in edit mode in project book, toggle to job costing.
select the cell which has the info you wish to up data in project book.
hit enter. done.
the formula you have created in project book will look some that like this...
=[Project Book.xls]Sheet1!A1
if job costing is closed, project book will still display the info but the
formula will now contain the entire file path to job costing.

Regards
FSt1
"Hoov" wrote:

I have two different excel documents. One is called "Job Costing" and the
other is the "Project Book". I update the Job Costing sheet daily, and then
I put the total from that sheet onto the Project Book when that particular
job is finished. It would be extremely helpful if the Project Book could
update automatically each time that I update the Job Costing sheet. However,
these two documents are on two different folders on our server, so I'm not
sure if that's possible. Is it?

Thanks so much!

Aaron

Another way that I like to use:

Open both workbooks.
Select the "sending" cell
edit|copy

Go to the receiving cell
edit|paste special|paste link

Excel will build the formula for you.

And when you close the sending workbook, excel will modify the formula to
include the drive/path.


Hoov wrote:

I have two different excel documents. One is called "Job Costing" and the
other is the "Project Book". I update the Job Costing sheet daily, and then
I put the total from that sheet onto the Project Book when that particular
job is finished. It would be extremely helpful if the Project Book could
update automatically each time that I update the Job Costing sheet. However,
these two documents are on two different folders on our server, so I'm not
sure if that's possible. Is it?

Thanks so much!

Aaron

--

Dave Peterson