You have chosen to sponsor your bid up to a maximum amount of .
I have a spreadsheet attached for your review.
I have one sheet called xls.Building 1. I do a web query to obtain this data daily in 15 min. intervals. I would like the query'd data to be stored into MS SQL if possible. Then, I would like a new sheet with some drop down style menus to allow me to select a date range. Say 10/1/2005 to 10/31/2005. Then be able to select get all buildings or selected buildings data. A macro would query the db and populate all the fields on my other sheets automatically. The query would need to take the difference between the first value on 10/1 and the last value on 10/31. Once the fields are populated. I would like another function to manually enter the cost for Energy (say .05 Cents per kwh)and generate an Invoice for each building. The attached spreadsheet only has data for Building 1, but there would be a similar sheet for all buildings or preferrably a query to MS SQL.