Excel VBA enabled form - project tracker
Budget: $250 – $750 AUD
I am looking for a skilled Excel VBA developer to create a project tracker form with the following requirements:
- Data entry: The form should allow for advanced data entry with multiple dynamic fields and dependencies.
- Visual elements: I would like the project tracker to include charts and graphs for data visualization.
- Automated calculations: The form should have automated calculations to assist with data analysis.
Ideal skills and experience for this job include:
- Proficiency in Excel VBA programming.
- Experience creating dynamic forms with advanced data entry capabilities.
- Knowledge of data visualization techniques using charts and graphs.
- Strong understanding of automated calculations in Excel.
Please provide examples of previous Excel VBA projects you have worked on, specifically those involving data entry and visualization.
Fields such as client , purchase order , award date , quote , GST (yes/no) total inc GS, invoice 1 value , invoice 1 date , invoice 2 value , invoice 2 date , invoice 3 value , invoice 3 date , invoice 4 value , invoice 4 date , invoice 5 value , invoice 5 date . Completed % , value remaining $
I would also like a chart of the total sum of purchase order cost $ versus remaining $ to invoice
- Data entry: The form should allow for advanced data entry with multiple dynamic fields and dependencies.
- Visual elements: I would like the project tracker to include charts and graphs for data visualization.
- Automated calculations: The form should have automated calculations to assist with data analysis.
Ideal skills and experience for this job include:
- Proficiency in Excel VBA programming.
- Experience creating dynamic forms with advanced data entry capabilities.
- Knowledge of data visualization techniques using charts and graphs.
- Strong understanding of automated calculations in Excel.
Please provide examples of previous Excel VBA projects you have worked on, specifically those involving data entry and visualization.
Fields such as client , purchase order , award date , quote , GST (yes/no) total inc GS, invoice 1 value , invoice 1 date , invoice 2 value , invoice 2 date , invoice 3 value , invoice 3 date , invoice 4 value , invoice 4 date , invoice 5 value , invoice 5 date . Completed % , value remaining $
I would also like a chart of the total sum of purchase order cost $ versus remaining $ to invoice