Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Reference to an Outside Excel Document
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? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Reference to an Outside Excel Document
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 "Jelytin" wrote: 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? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I reference a cell in another document in Excel formulas? | Excel Discussion (Misc queries) | |||
Reference to another document | Excel Discussion (Misc queries) | |||
How to create a formatted 'readable' document based on Excel document? | Excel Discussion (Misc queries) | |||
How to hyperlink in document so reference remains valid after a so | Excel Discussion (Misc queries) | |||
Reference the document properties in a cell | Excel Worksheet Functions |