Ask Your Question

Revision history [back]

click to hide/show revision 1
initial version

How can I create Pivote Table with Macro in LibreOffice Calc

Hello!

I have work with LibreOffice Macro.

I want to create pivot table with macro, because these data will change often. If I make it with macro, they will be otomatically.

I added a sample about my table, my first goal it to collect B Code. B code must be uniqe in my pivot table, and I want to collect G1,G2,G3 column if B Code is the same.

I added an example about my pivot table

How can I write it with Basic Code, Can you help me about it?

C:\fakepath\Example about Pivot Table.ods

How can I create Pivote Table with Macro in LibreOffice Calc

Hello!

I have work with LibreOffice Macro.

I want to create pivot table with macro, because these data will change often. If I make it with macro, they will be otomatically.

I added a sample about my table, my first goal it to collect B Code. B code must be uniqe in my pivot table, and I want to collect G1,G2,G3 column if B Code is the same.

I added an example about my pivot table

How can I write it with Basic Code, Can you help me about it?

C:\fakepath\Example about Pivot Table.ods