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- AccountCountryWeights111Australia15%111UK20%111USA35% 111China25%111Germany5%222Singapore18%222China28%222India12%222Japan35%222Thailand7%333Ireland5%333Poznan25%333Italy20%333Switzerland35%333France15% Expected Output data - AccountCountryWeights111USA35%111China25%111UK20% AccountCountryWeights222Japan35%222China28%222Singapore18%

Need help in building macro

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%

Macros

Accepted answers

caltang

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/

binu_acs

@anonymous_111 macro version

top_3_Percent.yxzp

All comments

caltang

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

caltang

Like so:

For Anon.yxmd

caltang

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

Output.xlsx

For Anon.yxzp

caltang

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.

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.

binu_acs

@anonymous_111 macro version

top_3_Percent.yxzp

Quick Links

This months top contributors

AkimasaKajitani 387

mceleavey 383

mbarone 337

Hollingsworth 335

LanisC 335