My problem is that i have a excel fil where i have absence data for all employees in a company. The data for each month is on seperate worksheets for jan, feb, mar ....Each worksheet contains a complete list of employees that current month.
I need to generate a page where the absence is summerized for each employee, but the problem is that a employee could maybe only be here 2 months, or maybe a employee is hired in the middel of the year. Because of this the list of employee on the main page should contain all employees who have been in the company over the year.
The list of employees have to contain 3 columns, a unique ID, a name, and a location.
How can i make this list dynamic so it always will include every employee who have worked in the company during the year?
The data about each employee i get with this formula =IF(ISERROR(VLOOKUP($A:$A;'Sep 2010'!$B:$D;3;FALSE));0;VLOOKUP($A:$A;'Sep 2010'!$B:$D;3;FALSE))
This method is quite slow. Is there a faster way of doing it? i cant use iferror() because the company runs Excel 2003
I need to generate a page where the absence is summerized for each employee, but the problem is that a employee could maybe only be here 2 months, or maybe a employee is hired in the middel of the year. Because of this the list of employee on the main page should contain all employees who have been in the company over the year.
The list of employees have to contain 3 columns, a unique ID, a name, and a location.
How can i make this list dynamic so it always will include every employee who have worked in the company during the year?
The data about each employee i get with this formula =IF(ISERROR(VLOOKUP($A:$A;'Sep 2010'!$B:$D;3;FALSE));0;VLOOKUP($A:$A;'Sep 2010'!$B:$D;3;FALSE))
This method is quite slow. Is there a faster way of doing it? i cant use iferror() because the company runs Excel 2003
