I have recorded macro for the data of 30000 lin items .
1. Selected data and created two sheets.
2. One sheet one type of data and another sheet another type of data.
3. Created pivot for the newly created sheets in 3rd sheet.
Now I should allocate this new sheet data by inserting a new colum with 6 names based on the line items each item. For example, if there are 30000 line items i should allocate this to 6 persons equally and refresh the pivot.
Could you please let me know what code should I insert in between theĀ recorded macro from steps 1 to 3?