Hi,

I am completely stuck in my attempt to create a Glitch Management System for the restaurant i work in. Using Excel 2007, I created a first sheet with the following columns: Date / Glitch / Department / Manager / Resolution / Status / Date Resolved. I have made it with filters and created a drop-down selection for Dept / Mngr / Status. Now, this first sheet is working well as far as I can tell. My problem is that I also want to be able to follow up on the Glitches using 2 additional work sheets - one for Unresolved / Pending issues (status) and the other one for Recently Resolved Issues (ie. within the past 2 weeks).

What is the best way to create these 2 additional worksheets? I have looked on several different sites but could not find a simple solution... is there one?

Thanks for the help, it is much appreciated.