I need help in developing an excel application which need to be able to populate and calculate huge data source of 270 fields wide and up to 5000 records long.
The main report will be an interactive Gantt chart with tools to reload the source file, refresh and navigate the chart viewing timelines of 3 milestones of baseline, forecast, and actual dates. This report should be able to show dynamic data in 3 lines which will be controlled by a horizontal and vertical scroll bar. There’re also 2 categories with each 17 buttons to present each report popping up as another tabs by filtering selected fields based on specific conditions of another fields.
The excel app should have a Config Sheet in order to set many ranges of fields and values to filter the source data which need to be shown in the chart as desire.
This is only for those who called themselves an Excel Expert and the chosen will need to be able to give his/her available time to improve this app in the future (of course with another deal). I myself have a high knowledge for excel features, formulas and designs, so I know what I want and what I am doing, however will need help from an expert vba coder. Don’t waste your bid quota!
Finally, this app will need to be wrapped up with a restricted access when it reaches predefined expiry date in order to make sure the users are using the latest update of it.
16 freelancers are bidding on average $172 for this job
Hi, I am expert in this kind of work and already completed more than 200 projects. Please look at my feedback to know more about my work. Waiting for more details. tks.
Very very high level Excel-VBA Expert here 15+ yrs experience developing Excel Macros. 20+ Yrs. overall experience developing IT Solutions using Microsoft technologies.
I have high skills on excel and Visual Basic along with great professionalism. I'm giving you a very low rate just because I'm new to this site. I want to see the source file.