The concept sounded simple. Copy the cells from the main worksheet and past it as a link in another. What I thought this meant was that any changes made in the original worksheet would automatically be made in the linked worksheet. Consider the database I am using as basically an extensive address books with all sorts of information - some missing when original entries are made and added later, other existing entries changed, and finally additions to the database (new rows)

The only changes that were quickly obvious in the linked worksheet were rows of #ref! in cells that were linked to rows that had been deleted in the original, and a cursory look showed that changes had not been made or additions added in the linked data ---- so clearly I don't get it. Can you help?

Thanks,
Trudy