Launch pivot table using Macro

[Tyrone Lopez]

Help! I created a simple macro to launch a pivot table covering dat
with fields as follows:

Date Units Amount

I created a pivot table manually and the results was correct. Created
macro with the same instructions, tested it and it worked. However late
with a longer list of data the macro did not provide a correct answer a
compared to a manually created pivot table.

Any clue as to the problem? Does a pivot table created through a macr
'retain' the data range and therefore gives an incorrect result if th
data range is longer than the original

 

[Debra Dalgleish]

In your macro, you could use a dynamic range as the pivot table source,
and it would automatically expand to include new data. There are
instructions here:

http://www.contextures.com/xlPivot01.html