Macro for Allocation of same company for count of people

[syed_ajmal1109]

Hello All,

I am looking for a macro where I should allocate 2000 company names for 7 team members (which can vary from time to time).

The macro should first sort the company names in order, then create a blank row in between the company names then allocate each company data equally to team members.

Thanks S

 

[vletm]

syed_ajmal1109
Please, reread Forum Rules

Site Rules - New Users - Please Read

Hi all, Welcome to the Chandoo.org Forums. Posting Rules & Etiquette The Chandoo.org Forums is a collaborative and happy place to learn and expand your Excel knowledge. The Chandoo.org Forums consist of several Sub-Forums based on the type of question/area of Excel you are interested in...

chandoo.org

and
after that continue with those.