Macro to extract data based on certain criteria

[amandeep08]

I have one sales report having 4 sheets each containing 8 Lac rows. D Column contain customer name.

I have another data where customer name and weekly time period (Weekly, Bi-Weekly or monthly) and date is mentioned is mentioned.

I want to extract the data from 4 sheets based on the second file from a macro.

I want to run the query that if i will select weekly and date range, Macro will fetch all records from 4 sheets and provide me the sales report of all the customers mentioned in the second file mapped to weekly billing as per date range.

 

[amandeep08]

Dear All,

Can someone pl help here:

Below is my Query:

I have one sales report having 4 sheets each containing 8 Lac rows. B Column contain customer name.

I have another data where customer name and date is mentioned.

I want to extract the data from 4 sheets based on the second file from a macro.

I want to run the query that if i will date range, Macro will fetch all records from 4 sheets and provide me the sales report of all the customers mentioned in the second file mapped to customer name and date range.

In the image, raw data is in sheet 1 while the master is in sheet 2. Once i run the query, it will fetch the yellow line items from sheet 1 and prepare the another sheet.