E
Excel Hates Me
I have an issue similar to this one:
http://groups.google.com/group/micr...4eb8cae/e376f663c98ae9fd?lnk=gst&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!
http://groups.google.com/group/micr...4eb8cae/e376f663c98ae9fd?lnk=gst&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!