• 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.

Recent content by Macao

  1. M

    Data in columns to rows..

    It actually worked, I had to give it a second try ;) Thanks!!!
  2. M

    Data in columns to rows..

    But that does not work, because the weeks are arranged as columns like this: Name Product Week1 Week2 Week3.. I want the data to be so that the "Week" columns are put in rows: Name Product Week1 Week2 Week3 Again the example does not show correctly above, but pretend that "Week2" and...
  3. M

    Data in columns to rows..

    I have some data arranged like this: week 1 week 2 week 3 week 4 a b c 50 60 70 80 d e f 2 3 4 5 g h i 44 45 46 47 But I would like to have it like this: a b c week 1 50 a b c week 2 60 a b c week 3 70 a b c week 4 80 d e f week 1 2 d e f week 2 3 d e f week 3 4 d e f...
  4. M

    Hello .. Introduce yourself

    Hello! I'm Marko from Helsinki, Finland. I work in a chemicals company as a controller, and currently I'm trying to build different kinds of dashboards in Excel for various reports that I do monthly. I took a VBA course in my university a few years ago, but my interest in macros was recently...
  5. M

    How to prevent filtering in pivots, if a pivotField is not among report filters?

    Hi! I have several pivot tables in a file, and in some of them a pivotField called "Month number" among the report filters. I also have a macro which, whenever I modify the "Month number" pivotField in the report filter in any of the pivot tables, sets the other pivot table filters equal as...
  6. M

    Macros don't work before refreshing pivot tables

    Sorry for my poor skills, I don't know how to write the code here so that it looks nice as the tab button doesn't work...
  7. M

    Macros don't work before refreshing pivot tables

    I do enable macros, but I have not saved the pivot tables with the underlying data to keep the file size small. I get the following error message when trying to use the PT: "The PivotTable report was saved without the underlying data. Use the Refresh Data command to update the report." This...
  8. M

    Macros don't work before refreshing pivot tables

    I have a problem with a macro, which changes pivot table filter values when I choose an item from a drop-down list in another worksheet. Everytime I open the file, the macro doesn't work before I refresh the pivot tables, and because all underlying data is stored in other Excel files the...
Back
Top