• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Search results

  1. A

    Open an excel from word and filter a particular column automatically [SOLVED]

    Hi, I have a word document with multiple sections in it. The detailed specifications of each section is available in an excel sheet. As there are multiple sections, each section has different specifications. The excel has many columns, out of which one column indicates the section name. All...
  2. A

    Reference to newly created Pivot Tables every time in a normal table [SOLVED]

    Hi, I used macros to create 3 different pivot tables in a one worksheet. I created a normal table which is a form of report whose calculations are based on the data from these 3 tables. Both these worksheets are in the same workbook. I used GetPivotData to refer to these pivot tables in the...
  3. A

    Excel Macro: Closing the Source workbook after Copy Paste [SOLVED]

    Hi, Requirements: I have a workbook by name Source with a worksheet by name Data. It has columns from A to E, but I don't mind how many rows and columns it has. I have a workbook by name DestBook with 3 worksheets - Dest1, Dest2, and Dest3 Purpose: Delete the existing contents in the...
  4. A

    Create pivot table in an existing sheet

    Hello, --------------------------------------------------------------------------------------- Purpose: Using a macro, I would like to create a pivot table from input source; but in an existing sheet ---------------------------------------------------------------------------------------...
  5. A

    Unable to get PivotItems property of the PivotField class [SOLVED]

    Hello, I did a search for this concept before posting it here. I'm new to VB and don't know much about the programming concepts. However, by recording the macro, i'm able to modify a VB code for creating a pivot table in an excel 2003...
Back
Top