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
Bookmarks