I have a monthly report I run each month. The data is always in the same format but the data and amount of data is always different. I created a pivot table to provide me with a simple count - types of new customers and the number of that type of customers. When I created the macro everything worked great it provided me with a list of new customer types, broke it down for me, and gave me the grand total. However when I run the macro all i get is the table with the grand total. What am I doing wrong?