drsatishtk
New Member
Hello, This is my first post on Chandoo. I'm new in macro. Actually I’m working on the macro which will allocate task randomly to the employee as per assigned percentage. I wasn’t able to prepare/get exact vba code for it. Requesting help on this.
E.g. I’ve a sheet with multiple columns (Column A - Task, Column B - Sample 1, Column C - Assigned To) & rows (contains tasks i.e. Task 1 to Task 8). Also I’ve employee list with percentage of allocation. Sachin - 50%, Rahul - 30%, Ajay - 20%.
Final outcome that I'm looking for is "- apply filter in column B (Sample 1) with criteria “A” & assign task randomly (in column C - Assigned To) to employee with their percentage on visible cells.
Thank you in advance.
E.g. I’ve a sheet with multiple columns (Column A - Task, Column B - Sample 1, Column C - Assigned To) & rows (contains tasks i.e. Task 1 to Task 8). Also I’ve employee list with percentage of allocation. Sachin - 50%, Rahul - 30%, Ajay - 20%.
Final outcome that I'm looking for is "- apply filter in column B (Sample 1) with criteria “A” & assign task randomly (in column C - Assigned To) to employee with their percentage on visible cells.
Thank you in advance.