Hello



I have a data set in one worksheet (i.e. "Invoice Breakdown") that I would like to have automatically summarised in another worksheet, as per "Invoice Summary". I have inserted a formula in column G of "Invoice Summary" which calculates the total amount of the invoice from the data set in "Invoice Breakdown". However, what I would need is for columns A to F in "Invoice Summary" to be automatically populated with the DISTINCT invoice numbers in column D and the associated information on columns A, B, C, E and F. At the moment, I use a filter on column D in "Invoice Breakdown" and copy the selected line across manually to "Invoice Summary". The attached is only a small sample, there can be hundreds of different invoices in a report. There must be a better way!

Thanks for your help

Attached Files

Sample Data.xls (46.0 KB, 9 views)

A pivot table is perfect here.

Thanks. I was trying to get away with not learning about pivot tables! However, I tried one and, for a basic thing like my query above, it wasn't too much of an ordeal.

Taryn