Excel VBA Script fixing and converting to Google Apps script to record customer information and produce custom Pivot Table Reports. Alternatively, rewrite the script as a standalone program.

Web, Mobile & Software Dev Scripts & Utilities Posted 1 year ago

Hourly Job

Less than 30 hrs/week
More than 6 months

Intermediate Level

I am looking for a mix of experience and value


We run a day nursery I have attempted to develop a VBA script for my staff to enter information about children in the nursery. The script should allow my staff to enter the information into a Userbox, and run various macros which produce PDFs created from Pivot Tables. However, since I am not a programmer, it is taking me far too long, and is inefficient.

Therefore, I require someone proficient in VBA to either fix my script, rewrite it from scratch in VBA, or rewrite it in another language such that it is compatible with Windows 7 and Windows 8, both 32-bit and 64-bit, and ideally then convert it into Google Apps Script. It must also be compatible with users regardless if their locale settings are set to dd/mm/yy or mm/dd/yy.

This job can be divided into three stages:

Stage 1) Working version, so that data can be input, and reports produced.
Stage 2) Adding more features, such as historic information (e.g. we are recording which Room the child is in; currently there is no ability to change the room, whilst maintaining historic information. So if we need to see where the child was last year, we do not have this option available.
Stage 3) Adding/changing features on request over an extended period of time.

Attached please find screenshots of what the app can currently do (in theory).

Important: For Stage-1, time is of the essence. You must be willing and able to start immediately, and work quickly.

Open Attachment

Skills Required:

Client Activity on this Job

Last Viewed: 1 year ago

Applicants: 14

Hired: 1

About the Client

(5.00) 2 reviews

United Kingdom
Salford 08:02 AM

13 Jobs Posted
70% Hire Rate, 1 Open Job

$4,819 Total Spent
9 Hires, 3 Active

$7.45/hr Avg Hourly Rate Paid
493 Hours

Member Since Nov 13, 2011