I have an excel work book with three work sheets as bellow,
above sheet contains all the sales details (i.e. Colombo(city or region)) for each month and the names of each sales persons, there is another sheet like this as collections in the same format to record collected cash amounts
in the above sheet the column header is a drop down list which user can select either sales or collection.
What I need to happen is when user selects sales or collection from the drop down appropriate data should be displayed against each sales person's name, year and month should be able to change too. Amal, Kamal, Nuwan, etc. are the names of each sales persons.