Macro to extract data based on certain criteria

amandeep08

Board Regular
Joined
Mar 20, 2011
Messages
115
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.
 
Last edited:

Excel Facts

Links? Where??
If Excel says you have links but you can't find them, go to Formulas, Name Manager. Look for old links to dead workbooks & delete.

amandeep08

Board Regular
Joined
Mar 20, 2011
Messages
115
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.
 

Attachments

  • Image.png
    Image.png
    59 KB · Views: 6

Forum statistics

Threads
1,141,073
Messages
5,704,140
Members
421,328
Latest member
mippy

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top