Excel- connecting data between two sheets? 2

[wahnula]

Hello all,

Sheet A & Sheet B, two independent sheets in the same database.

I would like to track and import the values from a cell or group of cells from Sheet B into Sheet A. If the values of these cells changes on Sheet B, it will be automatically reflected in Sheet A.

Is there an easy way to do this? Thanks!

Tony

 

[fneily]

First, it's a workbook, not a database.
Let's say you have a value in A2 on SheetB.
Then in A2 of SheetA put =SheetB!A2
Now when SheetB values change, so does SheetA.

 

[wahnula]

First, it's a workbook, not a database.

Thanks very much for your reply...I may have not been clear in my question.

Sheet A is its own workbook and is titled "Job Cost for Job 123" and stored in "Company" database. Sheet B is a different workbook and titled "Summary of Job Costs" and stored in the same "Company" database on our server. I would like the data that is entered into cell C85 on each separate 'Job Cost' workbook to be automatically updated in the "Summary" book.

Clear as mud???

Thanks for your time.

Tony



Tha

 

[coachdan]

The easiest way to connect two different workbooks like you are suggesting is to open both in a split screen format. In the first workbook, in cell A1, type"=" and then click in the 2nd workbook the same cell A1. It will create the path to the 2nd one for you. However, you will get pesky messages when you open the workbooks asking if you want to update the data from the other workbook. You can write a macro to get around it on open. There also can be some times when your cell references get corrupted due to one of the files being moved.

coachdan32

http://www.malehsbaseball.com

 

[firefytr]

However, you will get pesky messages when you open the workbooks asking if you want to update the data from the other workbook. You can write a macro to get around it on open.

Not if you go to Tools | Options | Calculation (tab) and check Update remote references and Save external link values.

Regards,
Zack Barresse

Simplicity is the ultimate sophistication. What is a Microsoft MVP? Professional Office Developers Association
- Leonardo da Vinci

 

[coachdan]

Nice add on Zack, I was not aware of that option

coachdan32

http://www.malehsbaseball.com

 

[wahnula]

You guys rock! Well done!

Tony

 

[wahnula]

One more question please...I noted when I did coach's suggestion the data always appeared in the same cell(A2 job cost = A2 Summary)...is there a way to get this value to insert itself into another cell on the second workbook?

Ideally it would be an adjustable option. Thanks!

Tony

 

[firefytr]

Without manually typing in the formulas where you want them to go (or copying down/over/etc) you'd probably need VBA (forum707)

Regards,
Zack Barresse

Simplicity is the ultimate sophistication. What is a MS MVP? PODA
- Leonardo da Vinci