Ask Experts Questions for FREE Help !
Ask
    ishtiaqahmed81's Avatar
    ishtiaqahmed81 Posts: 1, Reputation: 1
    New Member
     
    #1

    Aug 7, 2008, 02:35 AM
    Excel Sheets Connection!
    Dear All, (Sorry my question is not about word processor)

    I want to ask that how can be the data added automaticall to from one excel sheet to another. For e.g I have one excel sheet by the name ex1.xls and 2nd is ex2.xls. Let suppose I want to add something in ex1.xls and want the same addition in ex2.xls

    Kindly Guide me Properly.

    Regards!
    Ahmed

    >Moved to Spreadsheets<
    JBeaucaire's Avatar
    JBeaucaire Posts: 5,426, Reputation: 997
    Software Expert
     
    #2

    Aug 7, 2008, 07:54 AM
    Normally, inside a single document, for one cell to mirror the contents of another, you simply create a formula asking for the data from another cell. For a cell to show the contents of cell A1, the formula is:

    =a1

    If you want to show contents from another SHEET in the same workbook, you have it include the sheet name as well as the cell reference:

    =Sheet1!A1

    Finally, your question, if you want info from completely different workbook to display, you have to include the complete filename in the formula:

    ='[Customers.xls]Sheet1'!$A$1

    Notice the cell reference is no longer A1, it is $A$1, meaning it is an absolute reference. Also, this formula assumes both documents reside in the same folder on your hard drive. If they DON'T, you will need to include the fullpathname to the document in your formula:

    ='C:\Documents and Settings\Jerry2\My Documents\\[Customers.xls]Customers'!$A$1
    JBeaucaire's Avatar
    JBeaucaire Posts: 5,426, Reputation: 997
    Software Expert
     
    #3

    Aug 7, 2008, 07:59 AM
    By the way, the EASIEST way to create these links is to:
    1. Open both Excel documents
    2. In the target document, select the target cell and press = to start your formula
    3. Now switch over to the source document and click the source cell
    4. The formula has created itself complete with pathname and filename reference...press ENTER
      (You may not actually SEE the full pathname until you save and close your document, that's ok)
    5. Make other cell connections as required
    6. Close the source document
    7. Save target document


    NOTE: Every time you open the target document now, it will warn you that it found links to external documents and ask for permission to update the data. You should always say YES.
    ScottGem's Avatar
    ScottGem Posts: 64,966, Reputation: 6056
    Computer Expert and Renaissance Man
     
    #4

    Aug 7, 2008, 08:00 AM
    Just a word on terms here. A WORKSHEET is a grouping of rows and columns within a WORKBOOK. A WORKBOOK is a separate XLS file. So if you want to reference a value in a cell in an external Workbook, you need to refer to the workbook name (and path, if in another folder).

Not your question? Ask your question View similar questions

 

Question Tools Search this Question
Search this Question:

Advanced Search

Add your answer here.


Check out some similar questions!

Bed sheets [ 2 Answers ]

An extremely modest man was in the hospital for a Series of tests, the last of which had left his Bodily systems extremely upset. Upon making several false alarm trips to the Bathroom, he decided the latest episode was another And stayed put. He suddenly filled his bed with Diarrhea and was...

Connection of excel [ 1 Answers ]

How to connect one excel sheet to other excel sheet

Excel Budget Sheets [ 2 Answers ]

I am preparing for an job exam in Excel and would like to practice building budget sheets using formulas. Does any one now of any website out there were I can find samples of budgets sheets to build off? i.e Sums, then averages within sums> Thank You

Balance Sheets [ 1 Answers ]

On January 31, an entity's balance sheet showed net assets of $1,025 and liabilities of $225 Owners' equity on January 31 was: A) $ 800 B) $1,025 C) $1,250 D) $ 225


View more questions Search