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..

anyone please reply.....

anyone please reply.....

Sir, forgot the above report, i m attached a sheet & screen shot..
How much of the No Parties bill I want in the report from sales sheet of Selected Brand in Selected Month.

also i indicate in Pivot Sheet.

Thank you...

PIVOT.png
REPORT.png

Bakerman2, my super geniues sir,

where are you sir, Please help me..

PFA files for your reference hope your problem is solved

Sir , Thanks your reply , but i want VBA Code .