View Single Post
 
Old 04-21-2016, 06:53 AM
taryn taryn is offline Windows XP Office 2010 64bit
Novice
 
Join Date: Jan 2015
Location: Gibraltar
Posts: 21
taryn is on a distinguished road
Default Automatically extract cells to summary table

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
File Type: xls Sample Data.xls (46.0 KB, 11 views)
Reply With Quote