Linking between worksheets in Excel
Not what you're looking for?
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.