I am managing a call center with close to 200 people. For each request they receive they have to register 15-20 fields of information through an input form (let's call it Form A) in Excel. The information supplied on Form A is compiled in an Excel table, containing the fields of the input form. Then, when an operator needs to address a certain request, there is Form B, which reads information from the Excel table and displays it, with the operator being able to change part of the information (e.g. status of the request), which then updates the Excel table.
Our problem right now is that the Form A and Form B are based in an individual Excel file, where multiple users access simultaneously. This is generating errors when recording information.
What I need is an Excel based "system" where:
- There are only 3 files: Form A, Excel Table and Form B
- Users can access simultaneously to Form A or Form B and edit information, which then saves it to the Excel Table
- Access to Excel table is limited to one single user
I know there are better solutions than using Excel for this, but right now we will have to go with Excel.
I'm available for further clarifications.
47 freelancers are bidding on average €146 for this job
Hi, can you please tell me : 1. If you already have these forms and table ? (you current system). Also tell me how you are currently working ? (how the users access the same file at the same moment) . Thanks
Hi Jorge, I have 6 years of experience in Excel formula,macro,VBA and I will automate your excel sheet.I understood what you have mentioned all I need the data
Hello, I am proficient with Excel and VBA and would love to help. Can you tell me which version of Office do you use? Please contact me for more information.
No no no no no no! Excel will NOT work in a multiple user scenario. Let me build you a quick PROPER database solution which multiple users can access at the same time. Contact me Maurice Marinus