• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Create filtered list in new worksheet

jb

jb

Member
I have data of 60 employees on one sheet with multiple columns like employee number, employee name, days attended, no. of CL taken, no. of Medical leave taken and so on. Last column is attendance percentage.

Now I want to generate list of employees having attendance less than 80%.

This list is required to be generated on another sheet and it should be automatically updated. So at any point of time, it should display updated list of employees.
 
Hi JB, We can achieve this by a macro. First write a macro to generate list of employees having attendance less than 80%, then you can call the macro when ever a change is made in work sheet1 in order to get the latest updated details. Or you can call the macro whenever work sheet2 is opened.
 
You must log in or register to reply here.
Back
Top