linkling workbooks on a network

R

rufusf

Hi

Is there anyway of making 2 spreadsheets to update each other with
information?

What I am looking for is 2 different spreadsheets to be open (on 2
different PCs on a network) and when information on one spreadsheet is
entered that it automatically updates the 2nd spreadsheet – can this be
done?

Many thanks
 
C

Carim

Hi,

Technically it is called linking files ...
Practically just go ahead, while your two files are opened, simply
1. Type = in the destination workbook
2. Click on the cell you want in the source workbook ...

HTH
Cheers
Carim
 
Top