I have automated my spreadsheets to calculate based off of a Pivot table. As my data set goes updating, some columns in my pivot table are added or subtracted. In order for the automation that I have established to work properly, I need to add a (nonPivot) column off to the side as a numerical representation of every (Pivot) column.
Is there any way to program excel to add (or subtract) a column off to the side based on the number of columns in existence on a Pivot table. I would assume it would involve some sort of macro or vba manipulation. The idea would be that any time a column is added in a pivot, a column would also be created off to the side of the pivot with the correct formulas.
Any ideas? Let me know if you need more information.
Is there any way to program excel to add (or subtract) a column off to the side based on the number of columns in existence on a Pivot table. I would assume it would involve some sort of macro or vba manipulation. The idea would be that any time a column is added in a pivot, a column would also be created off to the side of the pivot with the correct formulas.
Any ideas? Let me know if you need more information.
