Sleeper: Pivot Tables [Archive]

View Full Version : Sleeper: Pivot Tables

ed123

09-20-2005, 09:49 AM

Does anyone know of a macro code that would update a pivot table as the source data was added to (i.e new rows of information are added to the data / rows are deleted)

Any help would be very much appreciated.

Kind regards,

Ed.:banghead:

Brandtrock

09-20-2005, 11:16 AM

Give this KB a whirl: Firefytr's entry (http://www.vbaexpress.com/kb/getarticle.php?kb_id=80)