Need help in building macro

[anonymous_111]

Hi,

I want to create a macro to update Top 3 countries data for respective accounts in different sheet with sheet name as of Account number.

Can someone please suggest workflow?

Sample Input Data-

Account	Country	Weights
111	Australia	15%
111	UK	20%
111	USA	35%
111	China	25%
111	Germany	5%
222	Singapore	18%
222	China	28%
222	India	12%
222	Japan	35%
222	Thailand	7%
333	Ireland	5%
333	Poznan	25%
333	Italy	20%
333	Switzerland	35%
333	France	15%

Expected Output data -

Account	Country	Weights
111	USA	35%
111	China	25%
111	UK	20%

Account	Country	Weights
222	Japan	35%
222	China	28%
222	Singapore	18%

[caltang]

I don't think you need a macro for this. The Sample tool will suffice.

[caltang]

Like so:

[caltang]

If you want to output it to multiple sheets, here's how:

[caltang · Accepted solution]

Just be sure to change the Output tool from "Create New Sheet" to "Overwrite..." once you want to run mutliple times after your first run or if the file already exists. 

Change the path in the Formula tool to point to where you want to save it. 

If the above solved your need, kindly like & mark as accepted solution so that you may help others find the solution more quickly + to close the thread as is. Thanks!

Best regards,
Calvin Tang
https://www.linkedin.com/in/calvintangkw/

[spunyar]

Thank you for your response. The data posted is just a sample; I have around 100 accounts and want to filter out 10 of them before updating the top three countries and I need data in separate tabs for each account.

That's why I was wondering if macro could help me create workflow in fewer steps.

[binuacs · Accepted solution]

@anonymous_111 macro version