RE: $$Excel-Macros$$ Re: Need help in building pivot using vba

2012-01-30 Thread Rajan_Verma
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.

Re: $$Excel-Macros$$ Re: Need help in building pivot using vba

2012-01-28 Thread rekha siri
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

$$Excel-Macros$$ Re: Need help in building pivot using vba

2012-01-26 Thread rekha siri
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