Sumifs results in a table format

Hi,

This is my first post in this Forum,

I have used one of the example for sumifs, which was very useful, thank you so much, i would like to get the results in a Table format, I'm attaching the test file with the vba code and the desired output, I'm not sure how to amend the vba code to get this results.

appreciate for your suggestions.

thanks
ale

Explain why 2018/1/1 POU12447603 has 2 lines while others have only one line?

Thank you very much jindon for your time, we receive data based on the order status, The same order could go up to 5 status (laycmp\layint\laydel\return\partial\laydel)
In the current test file the order POU12447603 has layint and laydel status.

thanks
ale

Dear Jindon,

My apologies, in the desired result, i have put wrongly two line for POU12447603, it should be only unique values

thanks
ale

Is the header in result fixed as they are or dynamic?

Dear Jindon,

It is dynamic based on the column c (fin_status_new)

regards
ale

Try

Please Login or Register  to view this content.

Dear Jindon,

Thank you so much, yes, this works perfect, i believe this is the simplest and the fastest code for Sumifs in table format. Thanks again

I think it can be done by Pivot table or msquery as well.

Thanks for the rep.

If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED.