Explore BrainMass

Explore BrainMass

    Linking between worksheets in Excel

    This content was COPIED from BrainMass.com - View the original, and get the already-completed solution here!

    I have an accounting assignment in which I have to use an Excel spreadsheet template.
    My problem is that in the spreadsheet I have been asked to LINK between the journals to the ledgers, to the Trial Balance, to the reports. What does this mean and how do you do it? I have attached the spreadsheet template I have to use for your convenience.

    © BrainMass Inc. brainmass.com June 3, 2020, 5:24 pm ad1c9bdddf
    https://brainmass.com/business/finance/linking-between-worksheets-in-excel-25012

    Attachments

    Solution Preview

    Linking means that the information you enter into one worksheet within a workbook will be the same information that will appear in other worksheets. For example, if you have depreciation on all of your worksheets as 27,000, then if you link all of the worksheets, the number will show up on all when you type in the number only on one. Then when you go back and start changing numbers you don't have to change it on all worksheets since they are linked. This also helps in calculations as it adds the information automatically when you enter it ...

    $2.19

    ADVERTISEMENT