I have an excel spreadsheet showing all my staff and what they output last
week. Numerous staff work in more than one location and therefore when
compiled there are several lines for them with about 30 columns of totals for
each output type.

I am looking for a macro to sort the combined sheet into alphabetical order,
delete any blank lines or ones with '0' then replace any users with more than
one record with just one total row.