Imranmanasiya
New Member
- Joined
- Dec 29, 2016
- Messages
- 2
Hello all,
I have a worksheet (Named ad FTR Details) which has a data for 33 columns and more than 1000 Rows. I need to filter the data on the basis of Month and the Team member. Criteria is based on a different sheet called as DASHBOARD. In Cell D2, I have a drop down where in I select the name and Cell H2 has a month where I select the month and the data should get filtered based on the Criteria D2 and H2. Also if I make both the criteria cells (i.e. D2 and H2 on Sheet "DASHBOARD") blank, if should remove all the filter from my worksheet (FTR Details)
Imran
I have a worksheet (Named ad FTR Details) which has a data for 33 columns and more than 1000 Rows. I need to filter the data on the basis of Month and the Team member. Criteria is based on a different sheet called as DASHBOARD. In Cell D2, I have a drop down where in I select the name and Cell H2 has a month where I select the month and the data should get filtered based on the Criteria D2 and H2. Also if I make both the criteria cells (i.e. D2 and H2 on Sheet "DASHBOARD") blank, if should remove all the filter from my worksheet (FTR Details)
Imran