Automatically update a 2 lists

A

Allan

I have two identical lists in 2 separate speadsheets.
How can I automatically update both lists by only entering new data into one
os the lists.
 
G

Gord Dibben

Allan

Check out help on "linking" or "links".

Note: you can only go one way using links.

i.e. you cannot link sheet1 to sheet2 and sheet2 to sheet1 using same cells.


Gord Dibben Excel MVP
 
Top