i basically need to know how to get the total vendor amount to move at least one of the vendors multiple name. for example if i sort by date the same name vendors won't be grouped which i don't mind all i need is for example if i sort the date you can see the vendor orly city sports wear has 4 invoices and next to the last invoice amount is the total of all the invoices together so after sorting the date how can i get that total vendor amount to stick to at least one of the lines of that vendor name like basically make it attached and also the 13,502.35 is generated from a formula =SUM(D8:D11) so some how the formula will need to change some how and follow the amounts to the cells they go to after sorting the date or wtvr
[/URL][/IMG]