Hi

Post some sample data, along with the result you are looking for.

If desired, you can mail me a sample workbook with a description on what you
want and the result you expect.

Regards,
Per

"fishy" skrev i meddelelsen
...
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.