ScotlandsNeo
New Member
- Joined
- Nov 12, 2015
- Messages
- 10
Hi,
I have an issue where I created a workload distribution tool in excel that quite simply, when you click "next case" (button that has macro assigned) it cuts the data from another workbook where a table of cases are sitting ready to be worked.
The problem I have is that when 2 people have the workload tool open and run the macro by clicking "next case", the macro's both run and take the same data simultaneously. This is an issue as it means 2 people (or more) could be working the same cases, how can I stop this from happening?
Regards,
I have an issue where I created a workload distribution tool in excel that quite simply, when you click "next case" (button that has macro assigned) it cuts the data from another workbook where a table of cases are sitting ready to be worked.
The problem I have is that when 2 people have the workload tool open and run the macro by clicking "next case", the macro's both run and take the same data simultaneously. This is an issue as it means 2 people (or more) could be working the same cases, how can I stop this from happening?
Regards,