convert code from filter to loop with array for big data

[MKLAQ]

Hello
I want changing this code for big data . every time increase data I note code will be slow . currently data are 25000 rows and will increase .
it will filter between two dates .

Please Login or Register  to view this content.

thanks

[Marc L]

Hello, you must try an advanced filter ...

[MKLAQ]

thanks , that doesn't solve slowness in big data .

[Marc L]

Wrong so you did not ever try it ! I used it with huge data and as your 25K rows are not such big ...

[beyond Excel]

Hello.
I'm not sure you understood that @Marc L's suggestion was to use Advanced Filter instead of AutoFilter.

In any case, I suggest you look at this method, which is usually efficient:

Please Login or Register  to view this content.

[MKLAQ]

@beyond Excel thanks but this gives the same speed , there is no difference.

[Sintek]

Upload sample file...

[MKLAQ]

@sintek file is big can't upload it

[beyond Excel]

@sintek file is big can't upload it

Please upload a workbook with no more than 1000 rows of data to the forum.

[Marc L]

@sintek file is big can't upload it

Save it as binary .xlsb at least, like for the advanced filter ...

[MKLAQ]

OK guys I uploaded file .

[Marc L]

According to your attachment an Excel basics VBA demonstration as a very beginner starter :

Sub Demo1()
    [A6].CurrentRegion.Clear
    [K1:L1] = sheet1.[A1]
    [K2:L2].Formula = [{"="">=""&C2","=""<=""&C3"}]
    sheet1.[A1].CurrentRegion.Columns("A:Q").AdvancedFilter 2, [K1:L2], [A6]
    [K1:L2].Clear
End Sub 

► Do you like it ? ► ► So thanks to click on bottom left star icon ? ★ Add Reputation ? ! ◄ ◄

[JohnTopley]

I did 30K records with the original code: almost instantaneous!

[MKLAQ]

thanks Marc L not big difference , but I accept your answering