|Subject:||How do I link data between spreadsheets?|
|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?