I did reply and received no response
Something is wrong I just typed a piece and it is not here either.
I can not be sum if to work. I just tried the subtotal function which gets me a little closer. I highlighted column M through AS and clicked on subtotal. I selected column M for subtotaling at each change and clicked each of the billing columns to subtotal. This still leaves me with data to clean up but does maybe half of the steps
My reply only works some of the time. I need the spreadsheet to show only one line of each address with the sub total amounts of the billing.
the pivot table was very combersome with all of the other columns and I could not quite get it the way I needed it. You have spent enough time on this. I'll just continue to clean them up manually.