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:
MTH1	MTH2	MTH3	MTH4
1	1	1	1
2	2	2	2
3	4	4	5
4	5	5	6
5		6	7
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.