Link cell from one open workbook to another

[mrsak87]

Hi,

I'm having a little trouble linking one cell to another. My objective is to paste an updating chart from one workbook to another and also link just one cell from one to another

The chart part works but I can't get one cell to link to another

Basically I want D12 from DestWB to always reference the value from J5 in the SrcWB. I'm obviously missing a trick!

Please Login or Register  to view this content.

Thanks for any help

[mehmetcik]

I do not understand your issue, a simple formula will do that for you

Please Login or Register  to view this content.

Please Login or Register  to view this content.