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)
Private Sub Worksheet_Change(ByVal Target As Range)
Application.EnableEvents = False
PivotTables("PivotTable1").PivotCache.Refresh
Application.EnableEvents = True
End Sub
Bookmarks