I have an issue similar to this one:

http://groups.google.com/group/micro...t&q=merge+rows

However, I have a few differences:

1. I have multiple worksheets (non-static)
2. Cannot use subtotals or pivottables (non-negotiable and not my
call)
4. Need to combine rows based on match in multiple columns
5. Where the cells are "" in the example above, I have zeroes (though
summing the rows might be a good idea just in case)

I have searched and nothing I have found seems to work. Any help would
be greatly appreciated. Thanks in advance!