Display excel table as calendar and pivot table in VB
$30-100 USD
Paid on delivery
I have a table (14 columns) that I need to view in several different ways. The best way is perhaps to convert this to a VB applications. I entered daily rows of data that I need to keep track of. All of the rows specify purchases for different time periods...and its difficult to keep track of when these time periods need to be renewed. So I would like to create a calender (with each column representing 1 day) to visualize how far out my purchases area. There would be 3 tabs to this spreadsheet/application: Inputs, results, financials. The inputs tab is basically the same thing I have on my spreadsheet right now. The second tab is results, which would take the inputs and reformat them into a calender of purchases. Each day in the calender would be a column and the different purchases I make would be listed down the rows (about 8 possible different purchases per day). The third tab is the financial tab which is basically a pivot table of the inputs tab. Specifically I need: a) See 2 rolling months on my results screen b) put note on each "results tab" cell with with information from "inuts tab". This would be displayed on a mouseover c) if there are multiple purchases for same time, add values together (comments should include both reference numbers described in (b) above) d) On the "results tab", the current date would always show at the left column. Yesterdays date would drop off e) Potentially need to put this solution on an intranet so others can access the info f) Each different contract (i.e. row on the inputs tab) show be displayed by alternating colors so I can see when each contract stopped/started. g) ability to add/edit notes to any box (notes icon would show) h) I want to be able to override a cell with a different number- if I override a cell, it becomes a red font (see row 2) i)history would be displayed on the results tab by choosing a different month via a dropdown list j) prefer to be able to add background color to selected cells so I can see which have been processed by myself k) need a legend to show what different colors mean l) program should have no outside dependencies as I need to put this on a intranet "public" files m) need existing spreadsheet brought into the new system. Please let me know if you have suggestions on whether excel or a VB (or other) application is best. I have attached a mockup so you have a good idea of what is required.
Project ID: #2817389
