Closed

Excel database with input and output forms that allows multiple users accessing simulatenously

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.

Best regards

jorge Santos

Skills: Data Processing, Database Programming, Excel, Microsoft Access, Visual Basic

See more: excel create input output, excel database input, excel database input template, wordpress plugin database input output, excel macro input output file, excel data input output, macro excel incremental input output, excel macro input output, excel log input output, excel file input output, add input output forms database, input output forms database, simple input output database, input output query database, inpuut output forms database development, vba access database multiple users, use forms excel database, add multiple users sql database

About the Employer:
( 3 reviews ) Lisboa, Portugal

Project ID: #16477722

47 freelancers are bidding on average €146 for this job

bouslimi1979

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

€100 EUR in 2 days
(217 Reviews)
7.3
schoudhary1553

Hi there..... Warm Greetings We came along with your request for Excel database with input and output forms and we reviewed your project description. We'd like to help you with confidence and satisfying results. More

€150 EUR in 2 days
(236 Reviews)
7.4
SBITServices

Hello Jorge , Why can't you go with google spread sheet, which is very reliable when using it parallel. With Excelwe will get concurrency problems even we coded it in better way. I have 5 years experience in E More

€75 EUR in 3 days
(291 Reviews)
7.2
ponnarasiBabu

I am an excel expert and have completed many complicated excel related tasks. Can provide you sample if required of my past and current work. Read the project specs - Excel database with input and output forms that all More

€277 EUR in 10 days
(158 Reviews)
6.8
Dhruvika111

Hello Jorge!! Hope you doing good. I have a better solution so that the file will be accessible to your complete team and whenever you need to update the data will automatically gets update and at the same time it wil More

€44 EUR in 1 day
(216 Reviews)
7.3
Tanmoy236

"I am an Excel Expert with Professional experience working with Excel both with Formulas and Macro. Working with complicated formula and Developing Macro programs are part and parcel of my daily work. I am a Business More

€150 EUR in 3 days
(118 Reviews)
6.1
seoguru17

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

€155 EUR in 3 days
(47 Reviews)
6.0
vlayausa

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.

€200 EUR in 3 days
(127 Reviews)
5.8
NourElDeen

Dear Sir, Your problem is easy to be solved just convert your excel sheet to Access database and let the database work as multi user system, all your team work together without any conflict and they all be updated wit More

€155 EUR in 3 days
(50 Reviews)
5.5
€166 EUR in 7 days
(28 Reviews)
5.8
jonathanpradas

Good day. Even though you said that excel is the right solution for this problem I will just put my bid here and will strongly suggest to use a database system such as MS Access for this problem. The data will be more More

€80 EUR in 1 day
(46 Reviews)
5.2
tiaratechies

Hello, we are a team of excel experts that are certified and experienced, if you are interested we can work on this.

€250 EUR in 3 days
(36 Reviews)
5.2
archanaoswal

I have excellent command on MS Excel. I can create the required database using Excel only so that multiple users can access it at a given time. I have completed complex projects in Excel before . For instance - Get More

€150 EUR in 3 days
(29 Reviews)
5.0
mauricemarinus

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

€100 EUR in 3 days
(40 Reviews)
5.1
solucionesnet

hi, I can develop a real system to capture and browse the info what you need to store using a real database also I can export data to excel file, don't pay twice let me build a database system for you. check my portf More

€216 EUR in 5 days
(14 Reviews)
4.9
alexanderrubtsov

Dear Mr. Santos, I assume the file with the table is placed on some computer in the local network, to which other people have access. The issue with simultaneous writing may be solved in the following way: a macro in More

€115 EUR in 3 days
(17 Reviews)
4.5
meeshal1994

Hello, I am web developer and also know excel. Now what you want can not be developed using excel because it does not meant to be used by more than a person at a given time. These 2 forms and one table can easily c More

€200 EUR in 8 days
(7 Reviews)
4.3
supper5guy

Hello there, after reading your project description and with a drive for excellence, with a keen attention to details and with more than 10 years experience working with Microsoft office especially excel vba, i can do More

€42 EUR in 2 days
(29 Reviews)
4.3
VBAautomation

As per your requirement MS Access database would be best solution. Why Access: Multiple user enabled, at a time 200 people can enter their data into one place. User specific login screen with individual authorizatio More

€200 EUR in 3 days
(12 Reviews)
4.2
soltecke

Regards, We are dedicated to the development of tools and solutions for SMEs and general users using the powerful excel tool. We also do not dedicate to statistical analysis and data science. We can develop More

€200 EUR in 10 days
(6 Reviews)
3.5