Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Macros?

Status
Not open for further replies.

LWinfrey

Technical User
Jan 18, 2000
16
US
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.
 
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.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top