I need to link 2 Excel Notebooks in 2 different areas of my office

[Guest]

I used to know how to link notebooks, but it has been a long time since I
needed to.
I need to keep two notebooks updated, exactly. When I make an entry into one
and save it I absolutely HAVE TO find it in the other notebook the next time
I open it. I do not have time to do this continual copy and paste routine. I
would appreciate directions on this matter at your earliest convenience.
Akoni

 

[Gordon]

I used to know how to link notebooks, but it has been a long time
since I needed to.
I need to keep two notebooks updated, exactly. When I make an entry
into one and save it I absolutely HAVE TO find it in the other
notebook the next time I open it. I do not have time to do this
continual copy and paste routine. I would appreciate directions on
this matter at your earliest convenience. Akoni

If you are talking about two excel spreadheets (Excel notebooks?) and you
are on a network, just save the sheet on a network drive such that it can be
opened by both machines. Easy.