Writing Code for creating pivot table

A lot of observations here for you to check your code.
1. You do not have to add a new sheet for the pivot, it will automatically go to a blank sheet or create one when creating the pivot.

2. You have coded the following -

Please Login or Register  to view this content.

You cannot specify the destination as Range("A3"). You need to specify the sheet where this range is present. You do not need to do this as well, since the pivot code takes care of it.

3. You have not specified a "Data" field in the pivot. Without that, the pivot wont work. I have just taken a dummy field (bl_number) in my code below.

4. See this code and let me know if it gives you any error.

Please Login or Register  to view this content.

Did this work for you?