Reference to an Outside Excel Document

[Guest]

Is there a way to have the data in an excel document be linked to another
excel document?

For example, I want to keep track of my charges and deposits to various
credit/debit cards. I'd like to have an excel document for each card. I'd
also like to have an excel document that keeps track of all card activity
with a column that notes which card the entry affects. Is there a way for me
to only have to input data into this master document have the other excel
documents automatically look at the list, select relevant entries based on
the card, and display them without me having to enter them myself?

 

[Guest]

Yes, there is. Without getting into the specifics of your application, here's
the principle. Have two spreadsheets open. In one spreadsheet (A) type an
equal sign in any cell, then click in cell x in the other spreadsheet (B).
Whatever value was in cell x in spreadsheet B will now appear in spreadsheet
A.

Rather than multiple spreadsheets or documents, why not just have one
workbook and use multiple worksheets?

cheers,
gt