I am looking for a VBA excel programmer to create an excel automated tool based on information entered via user forms. Tool must be both Mac & Windows OS compatible.
This project is for a transportation company that performs their own maintenance on their vehicles. The project is related to maintenance service schedules and the remaining interval (time/distance) till the next service. The main goals of the project are as follows:
1) automatically create/update 4 separate sheets for each service category (oil change/wheel service/truck wash & greasing/tyre change
a) that data entered via the user form will populate said tables.
2) each sheet will display the date/kilometres of the last service, the kilometres from the end of the previous day, and compare the interval vs the fixed service interval.
3) highlight vehicles that are within a certain metric (date AND distance) of the fixed service interval.
4) Create a dashboard sheet/table which displays vehicles NEARING their next fixed service interval
I have added an amended spreadsheet that contains two tabs. One tab "22 Nov" is an example of one of the 4 separate sheets; 22 Nov is for Oil Changes. The second tab is the service interval master sheet. The top displays the service interval rules while rows 9 and below display the last event. This is the data which will be used as a baseline. We will continue to add data and move forward from here.
This will be an ongoing project. I would prefer to use the same programmer as time goes on. The future version of this program will be a focus on the dashboard and visual metrics.
I am looking for freelancers with the lowest rates