I work for a college which uses alot of manual processes and procedures and is currently inefficient with these due to double handling of common information.
The solution i propose is to use microsoft excel as a platform (interface) which has a few worksheet databases in the background that contains all the student information required for several of these processes.
Let me begin by saying that I know all the background information (on what is required), have a solid(medium) understanding of VBA principals,userforms and macros.
As this is a big task with several different elements (I am looking for a honest, efficient and hard-working individual) who is reliable and can work-with me over several weeks to accomplish this.
Honestly, my total budget isn't great ($1000-1500), but I will provide all details of the job, each requirement clearly itemised and will communicate ASAP with any issues the person needs as questions arise.
I have all the data, templates, requirements etc itemised. For example lets say that there are 20 tasks I will need done.
For Task 1 (Student Enrolment Form):
-Have already built an excel userform
-Userform has 43 fields which reqires coding into database
-Have a list of requirements
ie. Qn 1. If user selects Option Button 1, then value must be A, else B
-Have the database in excel format which the enrolment form values need to be linked in to.
-Have a few other requirements such as a print option, error checks (will provide these in a list) etc.
I envisage a total of 12-15 tasks.
I will also provide a guide of what the total project is about, the overall proceses and where information is required from task to task.
I know what is required and have an understanding of what I need to do; problem is that I am an accountant by trade and not an expert VBA programmer.
What I am looking for is a hard-working, efficient, VBA coding expert who will take all my requirements and translate these into the actual codes what will result in the desired outcome.
For the right candidate, there will be ongoing work - I can promise you this.
I am looking to trial this person by asking for their assistance with the first task.
An enrolment form.
I have attached a quick example (not the actual work!) - so you can gauge:
1) My excel knowledge level (medium)
2) The level of details i will provide you.
3) My knowledge-gap!
Looking forward to getting some repsonses from reliable, committed people who would like to work long-term with me.
I am understanding, easy-going but also appreciate people who meet expectations and deadlines.
23 freelancers are bidding on average $462 for this job
Dear KP, I am an Excel and a macro programmer for 4years. I encountered a lot of work regarding Forms to Excel and Excel to forms. I have send you a personal message for full details of my proposal.