Does anyone know how best to navigate a pivot table sideways (i.e. on same row but from column to column) using VBA?
If I pick any pivot item in the pivot table, I can find its parent item or column heading within the same column by simply doing
Set obj = pivotItem.Paent
However, I've been...