Hello all you excel vba guru's...I've been searching for something that will count items in two columns. I have a spreadsheet with a Date column(A) and a Buisness Unit column (B). The date column is a custome format of yyyy-mm (2008-11, 2008-12, 2009-01...etc). The Business Unit column contains 11 different Business Units, ADMIN, COMML, RETL, IG, PRVBK and others. A third column lists Employee IDs (C). I'm looking to get an average number of employees during the last 12 month period for each of the business units.

There is a little more to this and I've used pivot tables and I'm trying to replace this with vba. This by the way is a turnover report. So I would ultimately be doing some math between these numbers and similar numbers from another sheet (a termination sheet - listing those that terminated the company during the same month's time). The excel sheet in question contains over 40000 rows of data. Each month I add the previous month's data....

I'm thinking the Date portion should be an array of some kind, listing the previous 12 months and then update that each month, by taking the oldest off and adding in the newest? Just not sure, if there are any suggestions to get me started...that would be great!!! Thanks...