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

    Formula Challenge 002 - Calculate Conditional Cumulative Sum

    is using your previous output classed as helper cells?
  2. E

    Fill-Down Macro

    This Macro will fill down the selected cell to the last cell with a value in. great for filling down formulas in list. it also only keeps the top most formula to reduce calculation times. I have included the multi filldown so multiple columns can be executed. Sub FillDown() Dim oWS As...
  3. E

    Pivot Table Updater

    This Macro will update all pivot tables in a workbook and reduce the filesize if there are multiple pivot tables from the same datasource. Sub Updatepivots() Dim pt As PivotTable Dim ws As Worksheet Dim pc As PivotCache Dim lastcache As Integer Application.ScreenUpdating = False On...
Back
Top