Auto Filter for 12 sheets ?

[staticbob]

Hi,

I have a spreadsheet for holiday tracking, with 12 sheets, one for each month. Is it possible to apply an auto-filter once, say in January on the department field, and have that apply auto for the other 11 sheets ?

Or could I use some controls on a front sheet, that prompts the user to select which department, it then applies that auto filter on all 12 sheets.

Thanks in advance
Bob

 

[earlyd]

Sounds like a macro is needed. Depending on your application, you may want to consider the old D... functions doing filtering the old-fashioned way.