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
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,
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