Automatically filter data in table based upon contents of one cell

Hey everyone,

I'm new to Excel Forum and a bit of a Luddite, so I'm hoping that someone here can help me with my question. I have a table in an excel worksheet that I need to filter on an automatic basis by entering a search criterion into a specific cell (say A33). I'm developing a performance measurement tool for work based on Canadian, US and Australian templates and I want to keep it as user-friendly as possible. I know that this can be done manually, but I want to keep things simple for my co-workers. I know that it is indeed possible to do this through VBA (http://blogs.msdn.com/b/gabhan_berry...vottables.aspx) but I don't want to do it for a PivotTable, just a simple flat table. That, and I'm not good enough with VBA to know which lines of code to manipulate.

I've attached the workbook I'm using below. The flat table I'd like to automatically sort is on the Data sheet in the bottom-left corner, starting with "SevereAlmost Certain." Any and all advice would be greatly appreciated.

Thanks in advance!

Mark

Project Management Dashboard.xls

If anyone is aware of any good Visual Basic tutorials that would help give me a better understanding of the coding language, that would also be incredibly helpful.

Mark

I've managed to track down the necessary code, and so far it works beautifully. However, it seems to be configured to only filter tables beginning in A1. Is there a way to alter the code so that it can filter tables in other places on the worksheet?

(The code can be found in the Fast Filter link)
http://www.contextures.com/excelfilesRoger.html