fayez_MrExcel
Active Member
- Joined
- Oct 29, 2005
- Messages
- 437
- Office Version
- 365
- Platform
- Windows
I have a employee master list in Sheet1 (Emp.No, Emp. Name, Date joined[dd/mm/yyyy], Status placed in A1-D1) and I have sheet2 wherein it will filter the data from sheet1 with 2 criteria.
In sheet2 I have: Data validation list of months (January-December) in E3 and Data validation list of Status (Active and Inactive) E4.
What I want to happen is to place a button wherein if I click it, it will filter the data matching the criteria selected in 2 data validation lists. And it will display the Emp.No, Emp. Name, Date joined, Status (C8-F8) in sheet2.
Please help. Thank you
In sheet2 I have: Data validation list of months (January-December) in E3 and Data validation list of Status (Active and Inactive) E4.
What I want to happen is to place a button wherein if I click it, it will filter the data matching the criteria selected in 2 data validation lists. And it will display the Emp.No, Emp. Name, Date joined, Status (C8-F8) in sheet2.
Please help. Thank you