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.
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.
