Hi Guys,
I am new here and this is my first post.
I am trying to distribute a list of data evenly throughout the list of people I have.
I am not sure how to describe it so I will upload the example excel as an attachment.
Do reply my post if you are unsure about my question. Thank you so much.
Last edited by sohlican; 12-11-2008 at 04:05 AM.
Welcome to the forum.
I have no idea what you're asking.
Entia non sunt multiplicanda sine necessitate
I guessed so.
I have a sheet (report)
if you look at it, i have a list of names there without any products.
then i have my data in the data sheet with a list of product id and the description of the products.
let's say for example,
i have 3 people in the list in report sheet and i have 21 products available in data sheet, i want those products to be distributed evenly to all the 3 people in report sheet automatically not doing it manually.
Is it possible?
Be easier to do it in reverse; add assignments to the Data sheet.
See attached.
thank shg for replying, i tried to modify the number of people and i added more products id, but the assignment of people just not evenly distributed.
Where did I miss out?
Sorry, see attached.
wow! Thanks man, this works exactly what I needed.
I will study on the formula
Thanks a lot!
If you are satisfied with the solution(s) provided, please mark your thread as Solved.
How to mark a thread Solved
Go to the first post
Click edit
Click Go Advanced
Just below the word Title you will see a dropdown with the word No prefix.
Change to Solved
Click Save
Re: Distribute Data Evenly
This is exactly the function that I need but I have no idea how to enter it in to my worksheet. Could anyone help?
I am trying to make an assignment sheet for my employees and I want to enter the assignments and the employees and distribute the assignments evenly among the employees. My issue is I have no idea how to enter that into a formula.
PLEASE SOMEONE HELP
Cortina47,
Welcome to the Forum, unfortunately:
Your post does not comply with Rule 2 of our Forum RULES. Don't post a question in the thread of another member -- start your own thread. If you feel it's particularly relevant, provide a link to the other thread. It makes sense to have a new thread for your question because a thread with numerous replies can be off putting & difficult to pick out relevant replies.
If I have helped, Don't forget to add to my reputation (click on the star below the post)
Don't forget to mark threads as "Solved" (Thread Tools->Mark thread as Solved)
Use code tags when posting your VBA code: [code] Your code here [/code]
Great Post Indeed "shg" you rock.....
Great post!
Great post sir!!
Good work
good job / excellent
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks