I have a spread sheet with dates in and i have managed to add macros to various areas to pool together certain options and data.

I have 4 boxes ready to pull together dates into Quarters. for example I want all date with dates including 1/4/13-30/6/13 this would be quarter 1. When I go to create a macro it doesnt work and the box just shows no data.

can anyone halp.