$$Excel-Macros$$ Data Filter

2015-10-12 Thread Rajeev Kumar
Dear Experts, Please see my query and solve the same 1) I have one *Logsheet* workbook with many data base 2) in Column A i have Area 3) Area divided in to 4 part as East, West, North & South. Now i made one *Topsheet* work book. 1) In the Topsheet workbook i made 4 text box as East, West, Nort

Re: $$Excel-Macros$$ How to apply multiple filters based on multiple criteria

2015-10-12 Thread Paul Schreiner
I went ahead and used =RANDBETWEEN() to randomly generate a sample file of 80,000 rows of data. I then created a list of the top 20 state/district combinations. I filter the Criteria sheet and run the macro: Report_Filtered_Records it takes anywhere from 15 to 45 seconds to search through the 80,

Re: $$Excel-Macros$$ How to apply multiple filters based on multiple criteria

2015-10-12 Thread Paul Schreiner
So, in Criteria sheet:you will hide/filter rows to display one or more rows,then you want to copy the data from the Raw Data sheet that match this criteria and place it in the Results sheet. does that sound correct? Is there any chance of getting a sample data sheet? there's several ways.There's