I am working on a fairly large spreadsheet. I have a list of names and their production (sales) over a twelve month period. I want to be able to total the production of each individual (since their names show up multiple times). I dont' want to use the subtotal function because it takes excel a long time to subtotal the entire spreadsheet. Also after subtotaling i will need to sort the information as well and with subtotal i cannot sort without losing the subtotals. Is there a way for me to do this using a macro? Thanks.