Creating a Glitch Management System to follow up on problems

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.

nicolashorvath,

It sounds like you want to filter and then copy/paste to a new sheet.

Hope that helps,
~tigeravatar

i've done that already. it's the copy-past part i am trying to automate... is there a way? thanks for the feedback!

all in all the extra sheets would be there to improve communication within the team so that we are all informed quickly without extra manipulations.

alright, i see what you're saying. thanks for your input and advice! Best to keep it simple then!