I need to create a search functionality within a pivto-table.. is this possible?
Apparently you are able to do this with the use of VBA, but i have no clue of VBA, and to that point Excel in advanced form.

I need to allow the user to search for specific dates within this pivot table... therefore the pivot table would come back with data within the search region... get me?

Also, this worksheet should (if possible) give some type of alert for date ends... example, if there is a particular deadline coming close by, the worksheet would alert the user (when worksheet loaded) that there is a deadline coming... is any of this possible?

If you are in any idea of how i can go about doing this, plz do get in touch... your help will be much appreciated.

Thanks