Is it possible to create a pivot table on a new sheet with VBA code?
The name of the active sheet will be different every time, so it needs to just be valid on the active sheet. The new sheet can be named anything.
For the pivot table, it needs to read columns A thru V (every row) on the active sheet, and I want the rows to be columns H and O, the columns to be columns P thru V, and the values to be the sum of P thru V. The header row names will also be different each time, so it needs to just be based on the column itself, not the name.
I tried to record the macro, but it keeps giving me errors, its really stumping me!!
The name of the active sheet will be different every time, so it needs to just be valid on the active sheet. The new sheet can be named anything.
For the pivot table, it needs to read columns A thru V (every row) on the active sheet, and I want the rows to be columns H and O, the columns to be columns P thru V, and the values to be the sum of P thru V. The header row names will also be different each time, so it needs to just be based on the column itself, not the name.
I tried to record the macro, but it keeps giving me errors, its really stumping me!!