$$Excel-Macros$$ Re: Filter Pivots

Hi, It's possible using macros: Public Sub AplicaFiltros() Dim auxWks As Worksheet Dim auxPivot As PivotTable On Error GoTo AplicaFiltros_ERRO For Each auxWks In ThisWorkbook.Worksheets For Each auxPivot In auxWks.PivotTables 'auxPivot.RefreshTable

$$Excel-Macros$$ Re: Index and Offset Formula Help

Hi, other possible solution is attached. Using offset and Array formula. Fabio --~--~-~--~~~---~--~~ - Some important links for excel users: 1. Excel and VBA Tutorials(Video an