jaydee
10-14-2012, 06:23 PM
Hi there,
Sorry to bother everyone, but I am trying to sum the amounts in col L, based on each change in col C. (i.e for every change in PO #, I would like the amounts summed and placed in the column next to it). I am trying to produce the highlighted values in yellow in column M without having to do it manually.
I know the subtotal function produces the totals, however it is located in the same column as the amounts making it hard to read and I have to use the subgroup feature to see the changes, but sometimes need to see all of the data
Can someone help if it's not too hard to write a macro?
Thank you
Sorry to bother everyone, but I am trying to sum the amounts in col L, based on each change in col C. (i.e for every change in PO #, I would like the amounts summed and placed in the column next to it). I am trying to produce the highlighted values in yellow in column M without having to do it manually.
I know the subtotal function produces the totals, however it is located in the same column as the amounts making it hard to read and I have to use the subgroup feature to see the changes, but sometimes need to see all of the data
Can someone help if it's not too hard to write a macro?
Thank you