How do I link data between spreadsheets?

Giganews Newsgroups
Subject: How do I link data between spreadsheets?
Posted by:  Allie
Date: Wed, 10 May 2006

I am using Excel 2003.  I want to be able to enter/update data in one
spreadsheet so that corresponding data in another, related spreadsheet also
updates automatically.  I think both spreadsheets will be in the same
workbook.  I also want to ensure that since the lines of each spreadsheet
will hold related data that the correct line is updated.

Is there a name for this procedure/formula?

Replies