Filter a column with a spin button

[SaraWitch]

Hello peeps,

Is there a way of filtering a column with a spin button? For example column D has a formula to work out the fiscal year from a date in column B. I have subtotal formulas further along working out costs and numbers, and would like to add a spinner to easily select the fiscal year (and, thereby, changing the subtotals).

Any help would be appreciated

 

[felixstraube]

One way is to create a pivot table from you data and add one of these controls:

Depending on if you year column is a date or just the number of the year.

Maybe you can show us some example data. Then we could help you more.