Invoke VBA | Create Edit Debug VBA | Refresh Multiple Pivots (Excel Automation UiPath) | Scenarios

[@parthmodi8792]

Hi Mukesh, is there any way we can shift filter row to row or something like that? in excel we drag and drop where we want but is there vb code available for that?

[@MukeshKala]

Most of the operation are possible with macro , I didn't get the Actual query ... What do you want to accomplish here ... Can u please give an example ..

[@parthmodi8792]

@@MukeshKala Thank you much for the reply, I have a column in filter field of of pivot table i need to drag the column from filter field to row field (in excel it is in show field where we drag columns in filter, column, row, sum), i need to shift that column from filter to row field.

[@MukeshKala]

A better way could be - 1. To Create a blank Template Excel Say - Template.xlsx 2. Add 2 Sheets to this Excel - Data and Pivots 3. In the Pivots Sheet - Add the Pivot You are working now and Take Data Reference from Data Sheet. 4. Now Initially your Data File and Pivot will be Blank . 5. Now when Bot is Running - we just Paste the Data in the Data Sheet . 6. Refresh the Pivot.

[@parthmodi8792]

@@MukeshKala Thank you very much for the solution !!!!!!