I have designed an userform to update a leave tracker.The input date (on the form) is getting saved on some other sheet in the following manner.
Employee_Name (column A1) Reporting_Manager(column B1) Type_of_Leave(column C1) Leave_Period_Start_date (column D1) Leave_Period_End_Date Comments(column E)
Each rows of these columns are getting filled one after another as the users filling up the form
Now I want to prepare a kind of an interactive dashbord which tells the manager how many resources are on leave/how many resources are available for a perticular period(manager should be able to select any date range) and which are the dates on which a person has taken leaves(however, we have only Leave_Period_Start_date and Leave_Period_End_date) as the input data)
Please post your thoughts if you have any suitable suggestions....