bug in vba macro to create pivot table

I am trying to automate creating a pivot table. I get a feed everyday from another department that contains 40 columns of data. I need to run same pivot table every day using 3 of these columns only (column B, J, & N)

Right now it is a very manual process.

The first pivot table is for column B & J where column B is row information of pivot table and column J is the data information.

The second pivot table is for column B & N where column B is row information of pivot table and column N is the data information.

Once I have both tables created, I then manually cut and paste information onto a separate sheet called Analysis.

Is there a way to do this manually? I have created a Macro but I keep getting a bug error and can’t figure out what is wrong with my code.

I have attached the spreadsheet of what I want the end result to be. The end result is sheet “Analysis”.

Thanks for any help.

Please Login or Register  to view this content.