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

    Prevent scrollbar control from changing current selection

    I use an ActiveX Scroll Bar control to allow a user to scroll among 10 rows that show fruits, with 5 rows/fruits showing at a time. When he selects a fruit by clicking in the range, rngFruits, a WorkSheetChange event assigns the row number for the selected fruit to valFruit_Row...
  2. H

    Dashboard based on multiple pivot tables or a single data table - performance?

    (Using Excel 2007.) I'm looking for advice about the performance (i.e., speed) of using pivot tables vs. data tables (Insert > Table) when you need to pull data from a very large worksheet of 10 columns and 100,000+ records. Is one typically faster than the other? My worksheet looks like...
  3. H

    Sort pivot table based on column selected

    I'm trying to use a macro to sort numeric values in a pivot table based on a column selected in another sheet. I've managed to capture the column number of the pivot on which the data should be sorted. This is stored in a variable, pivotColToSort. How can I pass the value of this column...
Back
Top