Macro split by company name

[sislam11]

Hi,

I am new to using macros in Alteryx and would appreciate some help.

I am unsure how to create a dynamic macro which can split the attached file based on company name.

Please see attached file.

The macro should take the data from the 'Data' tab and create the three output tabs by splitting the data by 'Company' column and also create a 'Total' which is the sum of the 'Net' and 'Tax' columns.

The macro should by dynamic as the number of companies can increase or decrease.

Many thanks in advance for your help!

[binuacs · Accepted solution]

@sislam11 You don't need a macro for this

[binuacs]

@sislam11 If you are still looking for a macro, here is one way of doing this

[Emmanuel_G]

@sislam11 

You don't need a macro for this case.

Find in attachement the way of doing that.