Hello,
I need to link cells from tables in 2 workbooks, so whenever a cell value is updated in the table in workbookA it should update in the table in workBookB and vice versa!
Well I linked them and they works perfectly in real time as long as they are both open, but when one is closed I have connection and link error!
I don't know if there is a way to this in different method then linking, maybe a formula maybe a vba it's too hard to figure out!
I attached the 2 workboooks here, hope someone has an idea
Thanks in advance forall.
Bookmarks