Work Allocation

[ashok0141]

Hi There,

I need macro code which allocates names to a data as per count mentioned in next cell

like

Name Count
Mahesh 50
Neha 40
Ramehs 60
Garima 12

and above names are allocated as per count.

Regards,
Ashok

[AliGW]

Welcome to the forum!

Sorry, but you have given nowhere near enough information for anyone to have any idea about what it is you are trying to do. Try again! Explain clearly.

[FDibbins]

I agree with Ali

To best describe or illustrate your problem you would be better off attaching a dummy workbook. The workbook should contain the same structure and some dummy data of the same type as the type you have in your real workbook - so, if a cell contains numbers & letters in this format abc-123 then that should be reflected in the dummy workbook.

To attach a file to your post,
click advanced (next to quick post),
scroll down until you see "manage file",
click that and select "add files" (top right corner).
click "select files" find your file, click "open" click "upload" click 'done" bottom right. click "submit reply"

Once the upload is completed the file name will appear below the input boxes in this window.
You can then close the window to return to the new post screen.

[ashok0141]

thanks for quick interest on my query...

i have attached the workbook as per need.

in the workbook, sheet"allocation details" where i have name of employee with number of cases to be allocated to each on sheet"data".

i need a macro to assigned to allocate button on the sheet "allocation Details" which allocate names on sheet"data" in the column "k"

I hope now you will be able to help me.

regards,
Ashok

[FDibbins]

ok, and the points shown on Allocate sheet are supposed to go where?

You need to show a before and after situation please. Remember, you know exactly what you want, we are working blind and dont have the knowledge that you do

[ashok0141]

on "allocation details" sheet , in column B, these are count of cases. if you can look at agent name Mahesh and his count is 15. i have manually pasted his name on data sheet for 15(as per count to be allocated) times. i need macro which do it for remaining employee through macro.

[ashok0141]

i am sorry, i am really not good in explaining the things.... but i will try if you need more explaination

[FDibbins]

Maybe you uploaded the incorrect file? Agent Name column is empty on Data sheet?

[ashok0141]

Here your go!!!

[ashok0141]

any update for me please

[nilem]

Hi ashok0141,
maybe so

Please Login or Register  to view this content.

[AliGW]

any update for me please

Please remember that those who help here do so voluntarily and of their own goodwill. They live in many different time zones and many will be out at work right now if they are not asleep on the other side of the globe. This is not a paid 'service': members will help when they are ready and able to do so, and not 'on demand'. Please do not try to put pressure of time on anyone here: if you get the help you need today, that's fine, but you really should not count on it. Thanks for your understanding and patience.

From the forum rules (link in the main menu above):

• If your question has not been answered within a day, consider adding another post with any additional information you believe is relevant. If you think your post is good as is, just reply to your own thread with the words "Bump no response", which will bring it to the top of the forum.

[ashok0141]

i agree with you

[ashok0141]

i am new on this forum so i was not aware of that how it work...

actually i was getting replies quickly so i was kept looking for solution.

i will take care of that in future and thanks you so much for help

[JeteMc]

As this thread has not been marked 'Solved', I am going to offer a formula based solution.
Place a helper column on the 'Data Allocation' sheet such that C1 is zero and C2:C6 are populated by: =SUM(B$2:B2)
The 'Agent Name' column (K) on the 'Data' sheet is populated by: =LOOKUP(ROW(1:1),'Allocation Details'!C$1:C$6,'Allocation Details'!A$2:A$7)
Zeros in column K are hidden using conditional formatting.
Let us know if you have any questions.

[ashok0141]

Thanks for making it easier

[JeteMc]

You're Welcome. Thank You for the feedback and for marking the thread as 'Solved'. I hope that you have a blessed day.

[Mohammedsamaan]

not able to see your macro, nither the button is working for the downloaded file