amandeep08
Board Regular
- Joined
- Mar 20, 2011
- Messages
- 130
- Office Version
- 365
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.
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: