Radio buttons & filtering data

I am trying to learn how to use macros with radio buttons. In the attached "test" file I've listed a simple data table. My goal is to assign a macro(s) to the four radio buttons that would accomplish the following:

1. By clicking on a radio button, the data will only show the companies/amounts/year that apply

2. The shown amounts of the companies must be able to sum correctly, and not include the filterer-out companies' amounts

I know the simple method would be to just use autofilter and subtotal, but I was hoping to get a bit fancy by using macros with run radio buttons to accomplish the procedure.

I would greatly appreciate any help on this. I'm very new to macros (still reading through textbooks), so please please excuse my ignorance.

Many thanks!

---
I placed the sample "test" excel file in the zip file

Hi,

No attachment

VBA Noob

You may need to look at the post I created here http://www.excelforum.com/showthread.php?t=583528
I think it is the same reason. Although not sure

Hi,

This example might help

VBA Noob