I have two workbooks "Tangible Capital Assets" and in the workbook are
worksheets with the various years, for example 2008-09. I also have another
workbook called "2008-09 Capital Submission" in that workbook I have a
worksheet called "Cap 11-Tangible Capital Assets".

I want to be able to update the worksheet 2008-09 in the "Tangible Capital
Assets" workbook and it automatically update the "Cap 11-Tangible Capital
Assets" worksheet in the other workbook.

Can someone please help me?

Thanks

Phil
I just tried this myself and it worked...
think of it as your main info page, ok? (Main Data)
After entering your data in the cell open the page where you want the data
to reside on that page then open the other file.
Now both are open.
Locate the cell in the 2nd file where you need it to reside. then hit the
"=" (in the upper left) its the "Edit Formula Icon" it will say "Formula
result =" then go back to first file and locate and click on the cell your
data that you want entered in your second file. Then every time you open that
file by itself it will ask to update the info if it has changed in the first
file.

Its as far as I gotten with it... I hope it helps you!


"yukon_phil" wrote:

I have two workbooks "Tangible Capital Assets" and in the workbook are
worksheets with the various years, for example 2008-09. I also have another
workbook called "2008-09 Capital Submission" in that workbook I have a
worksheet called "Cap 11-Tangible Capital Assets".

I want to be able to update the worksheet 2008-09 in the "Tangible Capital
Assets" workbook and it automatically update the "Cap 11-Tangible Capital
Assets" worksheet in the other workbook.

Can someone please help me?

Thanks

Thanks, I think from what I am reading your suggestion would update a cell
whereas I need the entire worksheet and the formating also. But I thought I
would give it a try, the part I am not sure of in your note is "What is the
"edit formula Icon" am not sure what that is.

"j5b9721" wrote:

Phil
I just tried this myself and it worked...
think of it as your main info page, ok? (Main Data)
After entering your data in the cell open the page where you want the data
to reside on that page then open the other file.
Now both are open.
Locate the cell in the 2nd file where you need it to reside. then hit the
"=" (in the upper left) its the "Edit Formula Icon" it will say "Formula
result =" then go back to first file and locate and click on the cell your
data that you want entered in your second file. Then every time you open that
file by itself it will ask to update the info if it has changed in the first
file.

Its as far as I gotten with it... I hope it helps you!


"yukon_phil" wrote:

I have two workbooks "Tangible Capital Assets" and in the workbook are
worksheets with the various years, for example 2008-09. I also have another
workbook called "2008-09 Capital Submission" in that workbook I have a
worksheet called "Cap 11-Tangible Capital Assets".

I want to be able to update the worksheet 2008-09 in the "Tangible Capital
Assets" workbook and it automatically update the "Cap 11-Tangible Capital
Assets" worksheet in the other workbook.

Can someone please help me?

Thanks