For word wrap problem - Column A has the Client name and then it is
blank until a new Client name in Column A. In the example A1 =
Client1, C1 = $400, D1 = $100, E1 = Employee1, A2 = the sum $2000, C2
= $500, D2 = blank, E2 = Employee2, etc. The client name is always in
Column A with the sum immediately below it and the amounts are
adjacent to A.

Thanks for the suggestion about putting the client name in each row.
The sheet is about 1000 rows with 100 different client names.