d oPT.PivotFields("Amount in local cur."), "Amount",
xlSum
wksPivotSheet.Name = "PivotSummary"
End Sub
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of rekha siri
Sent: Jan/Fri/2012 10:54
To: excel-macros@googlegroups.
hi Ansari,
I am bit new to vba coding as this pivot source data is within sheet as per
attached sheet .
*my query is *
if i have data in different sheet please advise.
can you please help to provide this below listed steps code
1) to copy particular sheet from one existing workbook to
Need pivot macro assistance..
On Wed, Jan 18, 2012 at 9:59 PM, rekha siri wrote:
> hi experts,
>
> Please provide the code to build pivot using vba
>
> this macro is provided to me in past by rajan really thank full for the
> concern.
>
> adding to that i need to prepare pivot for west bu