Extrapolating spreadsheet data

Welcome to the Forum!

There are a couple of ways you could approach this. First, I would suggest moving your summary table out of the line of fire of your primary data, either in K16 or another worksheet.

If you already know all the codes, and have a list of them in your summary table, you can used formulas with SUMIF. See example.

If you do not know the codes in advance, then a pivot table is your best solution. I also included that. It would not update automatically (two clicks to refresh) but a macro could be installed to update it when the data changes.

Edit: By the way, what you are doing is not extrapolation, it's summarizing. The thread title may have chased some people away

Originally Posted by djohnalyn

In the summary table how can I have it automatically add another code as a new code is added to the invoice?

Originally Posted by 6StringJazzer

If you do not know the codes in advance, then a pivot table is your best solution.

To refresh, right-click on any data element in the pivot table then click "refresh".

See attached. This macro will do it for you if you want to automate it. Put this code into the module for Sheet1(Invoice)

Please Login or Register  to view this content.

My non-macro solution.... in your other thread:

http://www.excelforum.com/excel-gene...ml#post2558284


Pivot table is the way to go, though.