I am trying to use VBA to look at column A which is a date, column E
which is the employee number. then it is supposed to add other
columns up on the same rows. I want it to add them up if they are the
same week. For instance employee 1 worked 11-5-07 and 11-7-07. I
want to add up both occuerences. So their production is in B and C, I
want to add up all of the B that meet the A and E requirements. then
I want to delete the rows that made up the sum.

Thanks,
Jay