Hello,
I am very new to macros and would really appreciate some help on this which I am sure is simple but I dont know where to start!

On the 'output' tab I want to be able to select - a team from a list in cell C2 and select the monthly periods in D4:O4 (which will change as need to be rolling months data)
The data is on 'staffnumbers' sheet which lists activities for all the teams by month.

I.e. - 'StaffNumbers'
Col B Col C Col D Col E etc....
Calls Team A 5 10
Quotes Team A 7 5
Calls Team B 6 9

Via a refresh button on the output sheet I want a macro to filter the selected Team on list in Col C tab 'StaffNumbers' and return each activity line for that team the monthly period data in col D:O on the 'Output' sheet.

Hope this makes sense.
Thank you