TopLearner
Board Regular
- Joined
- Feb 25, 2022
- Messages
- 57
- Office Version
- 365
- Platform
- Windows
Good afternoon,
I would like to create a Macro in VBA to eliminate the first row and then some columns whose headers I am listing below, and then create a pivot table.
1. To eliminate the first row
2. To eliminate columns: Employee number (A),Pay Class name (D), Pay type name E, Site (F),Pay category name (J)
3. To create a pivot table: Employee number, employee first name, employee last name, department name, job name and business name in the rows fields.
Can you please indicate the code to write in VBA?
Thanks
I would like to create a Macro in VBA to eliminate the first row and then some columns whose headers I am listing below, and then create a pivot table.
1. To eliminate the first row
2. To eliminate columns: Employee number (A),Pay Class name (D), Pay type name E, Site (F),Pay category name (J)
3. To create a pivot table: Employee number, employee first name, employee last name, department name, job name and business name in the rows fields.
Can you please indicate the code to write in VBA?
Thanks