Required Data Tab & reference wise

[Maheshp]

Hi Team,

I have the data, which need to be adjusted REFERENCE column wise but in different tab and required the total as well. Example shown in attached excel.

Regards,

Mahesh

[Maheshp]

adding" Reference is not fix" it changes every month, so it should be picked automatically.

[davidskaife]

Hi @Maheshp 

Here is a quick way of doing it, configuring the Output tool to take file/table name from the Reference Field and overwriting the sheet or range. A separate branch deals with totaling the amounts via Reference, which is then Unioned back into the main stream before outputting.

Workflow attached!

[dreldrel]

Agreed with @davidskaife , this is the quickest way. You can add a formula tool to specify your file path or sheet name if needed