employee staff tracker - hired and term date

hi,

i can't seem to find any in the forum regarding what i want to do in excel.

attached is the sample report that i want to create.

* i want the info in sheet 1 automatically populate whenever i add rows in sheet 2
* beg FTE counts the beginning number of staff hired for the month indicated
* end FTE counts the number of employees active less the number who left
* date start counts the number of employees who started/hired on the said month
* resignation/transfer/terminated counts the number of employees who left on the said month

i wanted to manage the running active employees that we have and how many left on a particular month.

thanks!

Hi agatha and welcome to the forum,

There are a lot of ways to keep your data. I've used your sheet 2 data and created a pivot table with the start dates grouped by month. This may be hard to understand at first but was very easy to do using a feature built into Excel called Pivot Tables. Look at http://www.edferrero.com/ExcelTutori...9/Default.aspx for more in depth training.

How you keep your data and how Excel can work with it is very important. Try some different ways, and start to learn Pivot Tables to see if they can help with your problem.

Try this.

Cheers,