How to sort 540 excel files based on H column by a VBA code?

[Behzadnavidi]

Hello all
I have 540 excel files (different in file names) in D:\Mrexcel\Fluff. The inside arrangement of them all is similar. The only difference is in the position of the last cells. Some have 6 rows in total, and some have the last row in 700.
I want to have a code to sort all the files by the H column (date).
Can anyone help me?
Here is one of my files:

Abali.xlsx

drive.google.com

thank you

 

[hernantorres23]

Hi, for me, could exists is several ways for do this, it depend what you want, after this process

Some of them:

• Power Query function, put will every file in same table, then you can report your data filtered
• Pandas (Python), my prefered way in this cases, I would take this way
• Wait for other anwser