I get an ftp everyday with an excel spreadsheet. Each spreadsheet is identical except the date. There are 16 columns and 48 rows. Each column has a tree name (like Aspen, Cedar, Birch) and each row has a name (like cash, accrued). The columns are an identifier and the rows are a statistic (usually a dollar amount).
What I need: The creation of a database that automated to update each day that stores the information in a nice format. So, for example, I could output the cash for Aspen for all days that existed.
Furthermore, I would like a button interface. The first set of buttons, I could check the tree names I want. The second set of buttons I could select the row names I want (like cash or accrued). The third set of buttons, I could select the time frame (like 11/2/2014 to 11/20/2014). Then , the result would be generated graphs and statistics displayed...as well as the data selected of all the 3 buttons.
I have a file I can show to serious workers on this. Not sure how much it should cost.
To clarify, the output and database that updates each day should contain ALL previous files. Like stacking matrices on top of each other and then pulling out slices of the cells.
42 freelancers are bidding on average $419 for this job
Dear, I am Access/VBA expert since 11 years. I checked your project description, and I confirm I can develop your Access DB. As you can see I have very good rate, you can be sure I am serious. Regards, Fabrice
Dear we have a team of 12 people that can handle your [url removed, login to view] have done many projects..we will follow according to your [url removed, login to view] only after the [url removed, login to view] will give you best result with limited [url removed, login to view] Mais
I can solve this in Excel. See my profile and contact me if you are interested. Thanks, Tom__________________________________________________________________