Database & Checklist Automation - open to bidding


1. Need to a UserForm that integrates the QC and SOP checklists I made in an Excel sheet. This should be an interactive so that employees can click a box & it will assign a certain value. Everyone will store with a score of 100 and if I select NO, it deducts point.

2. The checklists will collect data on several different workboos automatically & the checklists should be able to be used over and over again without the data being erased.

3. RIght now, I created several functions and relationships between certain excel sheets but I'm having trouble automating it all using Macro/VBA so that a score can be input in one locaion and it will automatically input that score in all other locations that will then calculate a final score.

3. These inspections are based on a 2-week period.

4. I also need a tool that will objectively randomize employee IDs, Names, and applicable Scores in small groups, all at once. In other words: if I have 200 total employees that are borken down into groups of 15, which are assigned to a specific Manager, I want to be able to randomize all 200 people at once but still attach them only to the manager they belong to. The same associates will be inspected by the same Manager each 2 weeks, but when they'll be inspected will vary on the randomizaiton.

5. I used the =RAND() function to randomize 200 people but then I realized that I would not be able to identify which employee belongs to which Manager. Once randomization is done, their names should be automatically populated onto an individual schedule hey work in. For this purpose of this project, I used fake names and employee ID #s.

6. This database/program will be used by warehouse managers, and the data has to be collected to run metrics from and be used for training purposes.

7. On the "Quality and Safety Checklist" excel, I have built the 2 checklists we will be using and the simulated calculation. The data input in the Quality and SOP checklist should populate in the calculations sheet and based on that, populate on the Final Score workbook every other Sunday as the final report.

8. The problem I have is that in excel, I do not know how to make the checklist stand-alone, in other words, link the score for each checklist to a specific employee ID and store that data on a seperate check. Then, I want to be able to refresh the checklist to use on a new employee, without erasing the data that was collected for the previous employee.

9. Is there a way to build a database in excel to where the same checklist sheet can be used over and over, but each data entry can be saved for an individual employee without the previous data deleted? I'm not too familiar with Access and know that excel is more user friendly with its broad functions.

Please ask me for clarification as I know it can be diffiuclt to understand at works.

Ideally, there will be ONE final score sheet that I can upload into our database or provide to management, and the other sheets will work systematically in the background.

Skills: Data Entry, Data Processing, Excel, Visual Basic, Visual Basic for Apps

See more:

About the Employer:
( 1 review ) Arlington, United States

Project ID: #12162183

18 freelancers are bidding on average $218 for this job


I have read your project description clearly and what I understood is you want to develop a excel app which collects checklists data from all employees and makes a report. We have good experience in Excel Apps developm More

$100 USD in 3 days
(134 Reviews)

Hello, my name is Cristian, I have a degree in Business and work with excel every day. I have much experience with spreadsheets, formulas, models and macros. Check my reviews. They speak for themselves. Best rega More

$200 USD in 5 days
(159 Reviews)

Hi, Thanks for such detail project description. I guess you are also an expert in excel formulas, it will be exicting jobs for both us us. I am sure I can help you through all your needs and make this spreadsheet More

$500 USD in 10 days
(190 Reviews)

Dear sir, Greetings. The features that you are trying to implement within Excel, won't give you.(Or compromise with some limitation) I would suggest you to use MS Access which is easy as well and give you extra co More

$188 USD in 3 days
(161 Reviews)

Hi, I have more than 14 years of Excel/VBA exp and I am expert in this kind of work. Please send me more details so that I can estimate cost and time better. I have completed more than 290 projects. Plea More

$200 USD in 15 days
(159 Reviews)

Hello, I am Excel and VBA expert. Can I see the file? Please note that I have 100% completion rate and 5-star feedback on 50 projects.

$188 USD in 3 days
(54 Reviews)

Self-motivated professional, certified data entry specialist, a proficient web researcher and transcriber, blogger, web designer, Wordpress and various social sites marketer, knowledgeable in SEO, and technical / help More

$100 USD in 5 days
(36 Reviews)

Greetings sir, i am an expert freelancer for this job and your 100% satisfaction is assured if you allow me to serve. Here is the reason. Why you should pick me? a) I am a very expert and have the same kind o More

$200 USD in 2 days
(70 Reviews)

Hi, Experienced Excel VBA and VB.Net Programmer. I have read your instructions carefully. Expertise in exchanging data between sheets, advance formulas, critical programming, developing system for management More

$120 USD in 3 days
(55 Reviews)

Greetings! I have 17+ years experience in using Excel as part of my daily work life. In the process I have implemented lot of automation similar to what you are expecting as well as dashboards for Management Reporti More

$200 USD in 5 days
(31 Reviews)

Hi, I am an expert in MS Excel, MS Access, SQL database production and management. I have over 7 years of experience in working with all of the databases and analytics. I am a financial engineering graduate and have e More

$100 USD in 5 days
(10 Reviews)

Hi, I have sound knowledge of Excel VBA programming. I can help complete the development and troubleshooting quickly with good quality once hired. Look forward to working with you. Best Regards,

$222 USD in 10 days
(2 Reviews)

Native English speaker. Excel/VBA expert. I've done such tasks before and can definitely take care of this for you. I recently build a similar evaluation system and can definitely picture how this will work. Howe More

$222 USD in 3 days
(1 Review)

This sounds like a complex spreadsheet. I didn't see the Excel file so I couldn't review the file. Here is how I typically approach a projects of this nature. 1) Understand how the file is currently working. 2) More

$250 USD in 3 days
(1 Review)

I am very experienced in VBA. I am an Access programmer and I have written automation projects in Word, Project and Excel. I have Microsoft Office 2000, 2002, 2003 and 2007 installed. The solution would also work in la More

$555 USD in 5 days
(0 Reviews)

I would like to apply and do the work as per instruction and I have good hand on Excel Macro and VBA. Regards Anuj

$155 USD in 3 days
(0 Reviews)

Hello, I understand the kind of project that you want to implement therefore after reading the requirements I would like to propose some simple solutions that I used before. SOLUTION1: The project will be splited More

$222 USD in 10 days
(1 Review)

Hi, I have good skill at typing speed, the data entry is accuracy and always able to control my time for on each project. Regards, Winnie.

$144 USD in 3 days
(0 Reviews)

Hi there My name is Ruben Ferreira. I am a Chartered Accountant (SA) and am considered by my peers to be a bits of a Excel and VBA expert. I would like the opportunity to take this project on - you give a lot of More

$158 USD in 7 days
(0 Reviews)