Purchase Solution

Linking between worksheets in Excel

Not what you're looking for?

Ask Custom Question

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.

Purchase this Solution

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 ...

Purchase this Solution

Free BrainMass Quizzes
Production and cost theory

Understanding production and cost phenomena will permit firms to make wise decisions concerning output volume.

Employee Orientation

Test your knowledge of employee orientation with this fun and informative quiz. This quiz is meant for beginner and advanced students as well as professionals already working in the HR field.

Operations Management

This quiz tests a student's knowledge about Operations Management

Social Media: Pinterest

This quiz introduces basic concepts of Pinterest social media

Understanding the Accounting Equation

These 10 questions help a new student of accounting to understand the basic premise of accounting and how it is applied to the business world.