Summarizing Data for Managers

Hello all,

I've attached the worksheet i'm working on so you can have a look. Basically, my problem is that every morning, data is pulled into the sheet in this form. The bosses want to be able to manipulate the data in Excel as easily as possible. For example, some would like to have the sum of HDD for a specific period of time for all weather stations, while others would like to have the daily values for one specific weather station.

To give you an idea of their skill level, I think that pivot tables would be too hard for them to do, and I personally dont think it would be flexible enough. Is there some way that I could write a VBA code and have UserForms that they could easily click and get the weather station they would want, the dates needed, and whether they want the HDD to be summed? Thanks for your help, it is much appreciated.


Stumped,
-Chris

Thank you it helped a lot!