HomeHome SearchSearch MenuMenu Our productsOur products

Manage your company's accounting better by linking your spreadsheets

by , 22 August 2014
Have you created links between your Excel spreadsheets yet?

No?

Well you should!

You see these links help you access data from different spreadsheets quickly. This means you don't have to go and open a different spreadsheet to look for that data. You just put in a particular formula and get the data you need.

It's that simple. But because you may still be in the process of getting to know your Excel you might not be familiar with this process.

That's why today, we're going to take you step-by-step and show you how to link your different Excel spreadsheets...

 
*********** Advertisement ************
 
 
***********************************
 

Here's how to create a link between different Excel spreadsheets

 
For the purpose of explaining how to create this links, we need to use an example of when you may need to use such a link. In this example, let's say you want to calculate your employees' salaries and their bonuses. 
 
So here are the steps you must follow:
 
1. Highlight the monthly sales (F7) and monthly salaries (D5) of employees in two different spreadsheets;
 
2. Give them their incentive based on their proportional gross income. Work out their wages in relation to the total sales from each employee;
 
3. Once you work this out, multiply the percentage by the number of employees. These two rates and the amount are in different spreadsheets. So how do you link them?
 
4. Just put an equal sign (=) in cell F7. And in D5 type an asterisk (*).
 
5. Reference the amount in the 'Monthly Sales' spreadsheet;
 
6. In the formula, after the asterisk, click the 'Monthly Sales' tab and then click cell D5. Notice the formula bar understands the Excel function you created;
 
7. This is the formula that Excel will create: =Table1[[#This Row],[Percentage of total]]*Sheet2!D5;
 
8. There mustn't be any spaces between the symbols in this formula or Excel will give you back an error code;
 
9. Repeat your formula for the other employees;
 
10. Calculate the monthly gross bonus for employees. You'll need to calculate the salary and the bonus; and
 
11. Now you've linked these two spreadsheets through this function.
 
This will help you access your information from two spreadsheets without having to open one and go searching for the details.
 


Related articles




Related articles



Related Products



Comments
0 comments


Recommended for You 

  Quick Tax Solutions for Busy Taxpayers – 35 tax answers at a glance



Here are all the most interesting, thought-provoking and common tax questions
asked by our subscribers over the last tax year – everything from A to Z!

To download Quick Tax Solutions for Busy Taxpayers – 35 tax answers at a glance click here now >>>
  Employees always sick? How to stop it today



Make sure you develop a leave policy to regulate sick leave in your company.

BONUS! You'll find an example of the leave policy and procedure in this report.

To download Employees always sick? How to stop it today click here now >>>
  Absenteeism: Little known ways to reduce absenteeism



This FREE e-report will tell you how you can reduce absenteeism in your workplace while avoiding the CCMA and without infringing your employees' labour rights.

To download Absenteeism: Little known ways to reduce absenteeism click here now >>>
  7 Health & safety strategies to save you thousands



Don't let a health and safety incident cost you one more cent. Implement these seven
strategies in your company today.

To download 7 Health & safety strategies to save you thousands click here now >>>