I have a list of employees with their hire and training dates for different departments. I need to use a drop box, select the date and department and populate the required fields in the second worksheet (dashboard). I know we can use a combination of index, match and row but I don't know how I can put them together ( I did index and match but when I select different month and department, the old employee population from the previous selection was not removed from the list, it needs to be refreshed for the new month and dept. selection). Thanks a lot.
10.5 KB Views: 6