none
how to move rows to columns using vb.net RRS feed

  • Question

  • I am able to create required pivot table using vb.net, add few columns with Sum formula. but i want to get those sum's in columns

    how to move values into "move to column labels" using vb.net


    S.Venkata Appaji

    Wednesday, December 23, 2015 6:53 PM

Answers

  • >>>how to move values into "move to column labels" using vb.net

    According to your description, you could record a macro, when you record a macro, the macro recorder records all the steps required to complete the actions that you want your macro to perform.
    You could change these VBA code into VB.Net code, you could refer to below VBA code:

    With ActiveSheet.PivotTables("PivotTable1").PivotFields("ProductName")
         .Orientation = xlColumnField
         .Position = 1
    End With

    For more information, click here to refer about How to: Record Macros

    • Proposed as answer by Ciprian Lupu Monday, December 28, 2015 3:05 PM
    • Marked as answer by David_JunFeng Tuesday, January 5, 2016 1:38 AM
    Friday, December 25, 2015 1:50 AM

All replies

  • Hi S.Venkata Appaji,

    This is the forum to discuss questions and feedback for Microsoft Excel, I'll move your question to the MSDN forum for Excel
    http://social.msdn.microsoft.com/Forums/en-US/home?forum=exceldev&filter=alltypes&sort=lastpostdesc

    The reason why we recommend posting appropriately is you will get the most qualified pool of respondents, and other partners who read the forums regularly can either share their knowledge or learn from your interaction with us. Thank you for your understanding.

    Regards,

    Emi Zhang
    TechNet Community Support


    Please mark the reply as an answer if you find it is helpful.

    If you have feedback for TechNet Support, contact tnmff@microsoft.com.
    Thursday, December 24, 2015 8:26 AM
  • >>>how to move values into "move to column labels" using vb.net

    According to your description, you could record a macro, when you record a macro, the macro recorder records all the steps required to complete the actions that you want your macro to perform.
    You could change these VBA code into VB.Net code, you could refer to below VBA code:

    With ActiveSheet.PivotTables("PivotTable1").PivotFields("ProductName")
         .Orientation = xlColumnField
         .Position = 1
    End With

    For more information, click here to refer about How to: Record Macros

    • Proposed as answer by Ciprian Lupu Monday, December 28, 2015 3:05 PM
    • Marked as answer by David_JunFeng Tuesday, January 5, 2016 1:38 AM
    Friday, December 25, 2015 1:50 AM