I have a datasheet that was given to me and I was asked to create filters to display specific data while simultaneously filtering dates. He would like to be able to make these changes with option buttons. I have no experience with Excel or macros, and despite being a technical person I've basically gotten nowhere.
The table stretches from columns A to AB and rows 1 to 10,000. Rows 1 through 12 make up the header. Column K is labeled Project Status and contains the words, either Open or Closed. I need to be able to turn this filter on and off, displaying all projects or just the Open projects, with two option buttons grouped together. I then need to be able to specify a date range that will work whether displaying either all or only open projects, essentially filtering the data even further. (ex. all Open projects in the last 6 months) The date range must be specified as follows
less than 3 months old
less than 6 months old
less than 1 year old
between 1 and 3 years old
between 3 and 5 years old
greater than 5 years old
7 more buttons would be placed in a separate group box to select those date ranges and the seventh button to display all the dates. This filter must also be calculated from the current date. I've had the most trouble with this as I'm not sure how to create a filter for the past five years, that will still be accurate in the years to come, without manually changing the date it's based on.
Any help with this would be greatly appreciated.