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