TheWennerWoman
Active Member
- Joined
- Aug 1, 2019
- Messages
- 301
- Office Version
- 365
- Platform
- Windows
I have tried using the macro recorder to create a pivot table and nothing appears. The code (about 80 lines of it) runs through without error but there's no pivot table created......does the macro recorder not work properly for pivot table creation?
I have a sheet called Variances - column A is called suffix, column B is called Source_A and column C is called Source_B. There's about 70 rows of data, all I'm looking to do is put the data into a pivot on the same sheet, suffix on the rows ,Sum Of Source_A, Sum Of Source_B as columns and then I'm adding a calculated field Sum Of Source A - Sum Of Source B so I can compare the two.
Does this have to be written from scratch?
Thank you for reading.
I have a sheet called Variances - column A is called suffix, column B is called Source_A and column C is called Source_B. There's about 70 rows of data, all I'm looking to do is put the data into a pivot on the same sheet, suffix on the rows ,Sum Of Source_A, Sum Of Source_B as columns and then I'm adding a calculated field Sum Of Source A - Sum Of Source B so I can compare the two.
Does this have to be written from scratch?
Thank you for reading.