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, 11 views)