Arun130691
New Member
Guys I just joined this forum and gone through the posts. It s really amazing and useful for all excel learner's.
I need now a macro for allocation of cases to the team.
1. Each user should get a individual spreadsheet of his/her cases
2. I have a specific column named "rate" which should not be allocated at the beginning so it should moved to a specific sheet in the workbook. A separate button should be available to distribute this data.
3. Cases should be assigned equally and a field is required to manually input the available of users daily so the macro allocated equally aaciding to that.
Can anyone please help me to do this !!!
I need now a macro for allocation of cases to the team.
1. Each user should get a individual spreadsheet of his/her cases
2. I have a specific column named "rate" which should not be allocated at the beginning so it should moved to a specific sheet in the workbook. A separate button should be available to distribute this data.
3. Cases should be assigned equally and a field is required to manually input the available of users daily so the macro allocated equally aaciding to that.
Can anyone please help me to do this !!!