Build Excel WIP (work in progress) and Dashboard with Form to enter Data., Lahore
Job Posted: 14.06.2021 7:55:40
Excel spreadsheet for ongoing workflow management. This is a project that will evolve over time and have several iterations. Initial – List of functions: A button that triggers a form User Form Collects Data – Combo box based on tables and dependent combo boxes (Firms then clients that work for that firm) Once form completed, data updated on Project Data Sheet All formula and VBA needs to be dynamic to allow for team growth Dashboard that indicated basic data – Number of Jobs at each stage I have attached a small sample of what I have started and that data I require on the "Project Data" worksheet. I have also posted a small video describing what I would like to happen. Once the first stage of project is completed there may be features I would like to add. However this can be a future project. At this stage a functioning dashboard, a form to add new projects and a data set that is somewhat automatically developed based on form entry would be greatly appreciated. I am also interested in triggering an email with the entered details, this can also be discusses if possible. I look forward to completing the job and working with someone who is somewhat flexible and able to make suggestions and recommendations as well as develop the required outcome.
