We have an excel app that has VB controls (combo boxes & listboxes) on a page with charts.? Based on the users' selections in the listboxes, certain cells are updated on a second worksheet which then change the chart data on the first page.? So all the user ever sees is the data in the chart changing with his various requests.? The problem is that this is updated frequently and therefore is not practical to re-distribute it everytime to the users.? We would rather put it online (using [url removed, login to view] OR OWC for excel).? ? NOTE:? THIS IS NOT A STANDARD [url removed, login to view] PROJECT.? We have already posted this several times due to bidders underestimating exactly what was needed.? YOU WILL HAVE TO SHOW A PROTOTYPE before we accept your bid.
See the attached worksheet.? The two sheets titled "pivottable_sales" & "pivottable_revenue" contain raw data.? The worksheet "dashboard" is currently the user interface.? Depeding on the user's selections in the combobox, the two listboxes populate dynamically.? Depending on the selections the user makes in those two listboxes, the cells "E3" & "H3" on worksheet "DATA 2" update to reflect those choices, which update the data in that worksheet and populate the charts on the "dashboard" page dynamically.
Typically the user only sees "dashboard" and makes their selections, real-time, and the charts update.? The difficulty we're having is translating this simple, VBA/excel application, into an [url removed, login to view] page that can be hosted on our server.?
Please contact us with an approximate time to delivery