Pivot Table / Open in New Workbook, Save As, Delete Data.

laurensims41

New Member
Joined
Feb 4, 2016
Messages
22
Hi All,

I am in need of some help here. All the VBA Codes I have tried to use don't work.

I am trying to open the information in a pivot table in a new worksheet (I have that part figured out but I cannot get it so it will allow me to add new sheets to my existing workbook every time it opens a new workbook)
I would like to take the code a few steps further and Save As to my C Drive in a folder named EOY VENDOR REPORT_Date_and the data in Column BA Row 2. (Once the Columns Delete though this many not end up in BA so I am not sure what to do here)
When the pivot opens in a new workbook I would like it to delete certain columns of data as well.
Columns B, C, E,M,P,Q,R,U,V,W,AA,AB,AC,AD,AE,AF,AS,AT,AU,AV,AW,AX,AY,AZ,BB

Any Help would be greatly appreciated.
 

Excel Facts

Excel Can Read to You
Customize Quick Access Toolbar. From All Commands, add Speak Cells or Speak Cells on Enter to QAT. Select cells. Press Speak Cells.

Forum statistics

Threads
1,213,550
Messages
6,114,265
Members
448,558
Latest member
aivin

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top