Macro Help for proportionately division of data by number of associates

[annupojupradeep]

Hi Team,


I am in problem to assign macro for below query;


I have data of 300 line items and 5 associates are there. I need to allocate the data only 240 line item out of 300 line items among the 5 associates proportionately and rest of 60 line items to be deleted.


Could you please help on this


Pradeep

 

[prasaddn]

Hi,


Just put the 5 names in available column and drag the names till you reach 240th line and then remove the rest lines.


Why need macro for this?


Regards,

Prasad DN

 

[annupojupradeep]

Hi Prasa,


Yes you right but what I want is I run the macro in SAP that data will be extracted and i need to call macro (Excel) from SAP, the above macro which i metioned earlier comments.


So I already run the macro for SAP but I am not able to run a macro in excel as per my requirement.


Could you please help...


Regards,

Pradeep

 

[NARAYANK991]

Hi Pradeep ,


Can you please clarify what you want to do ?


The more details you provide , the easier it will be for others to help.


If you find it difficult to explain , can you upload a sample workbook so that others can access it ?


Narayan

 

[jason001]

cheap oakley flak jacket are generally great type shades, seeing that oakley shades are designed together with best content for ever quality and also cheap oakley sunglasses sale possess many models and also colours for each of choice, simply no mater what exactly coloring you wish, people most of will find together with cheap oakley sunglasses usa. Oakley shades can be on discount sales inside our oakley sunglasses cheap sale, you are able to pick just about any affordable oakley shades together with ushttp://www.icheapoakleysunglasses.org.