Can we do pivot, Formulas, Macros using .xml File?

[Gokul_Jayakumar (Gokul Jai)]

Hello @PALKUMARI_PATEL
Kindly refer this tutorial

How To Generate an Pivot using Macros

Hello Everyone, Hope you are doing well I would like to present this post who are looking for the expressions related to Create an Pivot using VBA script Creating the Pivot using VBA Option Explicit Sub CreateNewSheet() ' ' CreateNewSheet Macro ' ' Dim wb As Workbook Dim ws As Worksheet Dim Name As String Dim SourceR As Range Dim TableName As String Set wb = ThisWorkbook Set SourceR = Range("A1").CurrentRegion TableName = "NewTable" Set ws = ActiveSheet With wb …