Macros?

[LWinfrey]

I have an Excel document that is used as a checklist. Is it possible to filter this checklist to create several smaller specific worksheets? For example, I would like to create, from the master worksheet, 6 seperate lists for 6 different departments without having to update both the master worksheet as well as the departmental one.

 

[BarryG]

Try using Pivot tables. You can create unique pivot tables on individual sheets that each specify different criteria and will be automatically updated as the main sheet's data changes.