pvt

  1. C

    Sort pivot table on grand total column

    Hi I need to sort a pivot table on the "Grand total" column. I have tried using the recorder, but i can't get it to work. The code I have is below, would anyone know how to finish it off please? Dim sht As Worksheet Dim pvtCache As PivotCache Dim pvt As PivotTable Dim rgPivot As Range Dim...
  2. A

    VBA to extract data from a sheet to new workbok

    Excel 2007 <colgroup><col><col><col><col><col><col><col><col><col span="2"><col><col><col><col><col></colgroup><tbody> Voucher Number Date Party Name Item Name Item Group Item Description MRP Item HSN Item GST Acutal Quantity Rate Unit Discount Discount Amount Amount 001/S/18-19/PN...
  3. S

    Changing data sorce to other tab of pivot table

    Hi Team, can anyone help me on the below Lets take example here!! One Tab(Pivot Name:- PVT) i have pivot which is linked to main Data (Sheet1) but in next month i have to update the new data in (Sheet2) and the same PVT (pivot) needs to be updated breaking the link to Sheet1 Tab Here the pivot...
  4. Y

    run-time error: Methods 'add' of object 'SlicerCaches' failed in Excel2016

    Hi all, So I created two pivot tables from the same source. What i want to do is to create a <code style="margin: 0px; padding: 1px 5px; border: 0px; font-variant-numeric: inherit; font-variant-east-asian: inherit; font-stretch: inherit; line-height: inherit; font-family: Consolas, Menlo...
  5. G

    Macro Filter by PVT, Copy, Create Files

    Getting an error on the red letters below dont know why and how to correct. Option Explicit Sub BankConsolidate3() Dim fPATH As String, fNAME As String, wbCSV As Workbook Dim LR As Long fPATH = "C:\Users\CliftG01\Documents\Test" fNAME = Dir(fPATH & "*.csv") Do...

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