Extracting the Count based on several Conditions

[ramesh31]

I have the Employee List and front of them have the city where they belong, I want to give the Customers to these employees based on category which i have created.

Table 1. So i have the Employee , city , and the count of customers needed from the category ( Two category 1 & 2)

Table 2. I have Customers and City and Category in next table.

I want to extract the Customers and want to give to the employee

I have mention the category wise count which is needed

Please help

Output needed :-

CUSTOMER NAME , CITY , CATEGORY , EMPLOYEE NAME

Attacing the Excel file for the same

[Reeza]

Is this different than the question you've posted in Base Programming? 

Please post sample data in your question, not as an attachment or image.