Comparing data across multiple columns

[jigabug]

Hi folks - first post here... Looks like a pretty awesome community.

I was recently told that one of the payroll employees where I work has spent nearly a week manually comparing employee numbers from month to month to see who has come/gone each month. I'm sure there's a way to do it in macros, but my coding skills went to the web ages ago and my VBA is not what it used to be - so I'd appreciate the help.

Here is a sample setup, in short:

Please Login or Register  to view this content.

So, month names work across row #1, and the badge numbers that were still with us at the end of that month work their way down. So, in the sample, employee #3 wasn't there after Month 1, and employee #6 started with us in Month 3.

She has this information on Sheet 1, and then on Sheet 2 she has the same headers in A, then she has "Joined" and "Left" sections below it in each column.

I'm sure there's a quick function or two (Some of my searching has lead me to http://support.microsoft.com/kb/213367) that would make this super easy... I just don't know them.

Any help would be greatly appreciated.

[SDruley]

Sometimes it is a matter of how the data is put into a table.
See attached.
The best program is no program at all.

[mrice]

Please try the attached.

[jigabug]

Sometimes it is a matter of how the data is put into a table.
See attached.
The best program is no program at all.

While I'd normally agree, we're working with 9 years of data and the company currently has about 800 employees (We've turned through about 1500 over our 9 years)... And we need the badge numbers for another project.

[jigabug]

Please try the attached.

That looks pretty close to what I'm looking for - gets me in the right direction at least. Thanks!

[SDruley]

The new attached workbook may provide another solution to your need to develop a resource utilization report for company. I guess I did not realize the scope of the challenge was so daunting.