Скачать с ютуб Create Pivot table with VBA Macro в хорошем качестве

Create Pivot table with VBA Macro

Create Pivot table with VBA Macro. Download Practice File : iturninstitute.com/excel_excercise.zip Udemy course details: 1. MS Office Training: https://www.udemy.com/ms-office-2010-... 2. Excel VBA Training: https://www.udemy.com/excel-vba-macro... 3. Excel Training in Hindi: https://www.udemy.com/excel-training-... 4. Excel Training in English: https://www.udemy.com/excel-training-... Courses in DVD: 1. Complete Excel (Excel + VBA – Macro) : https://www.amazon.in/dp/B07929BPRS 2. Excel VBA – Macro Training: https://www.amazon.in/dp/B0792BFQMC 3. Excel Training in Hindi: https://www.amazon.in/dp/B076B2TLNW 4. Excel Training in English: https://www.amazon.in/dp/B0769NFS82 Subbscribe to our youtube channel for latest update. For Classroom training at Noida: www.iturninstitute.com For our Blog: http://www.learnmisease.info/ Download the app for full training videos and tricks on Excel : https://play.google.com/store/apps/de... VBA Code: Option Explicit Sub trail_pivot12() Dim mypivot As PivotTable Dim mycache As PivotCache Sheet3.Activate Set mycache = ActiveWorkbook.PivotCaches.Create(xlDatabase, Range("a1").CurrentRegion) Sheets.Add , Sheets(Sheets.Count) Set mypivot = ActiveSheet.PivotTables.Add(mycache, Range("a4"), "Mypivot1") mypivot.PivotFields("Item").Orientation = xlRowField mypivot.PivotFields("Client").Orientation = xlColumnField mypivot.PivotFields("Sold").Orientation = xlDataField End Sub