Require VBA Code for Sales & No of Billed Customers

Dear All,

I Create Userform with list box..when i select 1st option in the listbox result will display in range(b4) & (b5) for Select Brand.
i want vba code for

1 ) Active No of Parties having of Selected Salesman.
2) Total No. of Sales in That Period / Month
3) No. of Parties billed in that particular Period / Month. of Selected Salesman & selected Brand.


i enclosed herewith xlsx. sheet & i report in the sheet what i want.

This report is my Final Report of MIS & Important Report.

anyone Please help..

Thank u for advance..