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

Behzadnavidi

New Member
Joined
Dec 15, 2019
Messages
4
Office Version
2019
Platform
Windows
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:
thank you
 

Some videos you may like

Excel Facts

Which Excel functions can ignore hidden rows?
The SUBTOTAL and AGGREGATE functions ignore hidden rows. AGGREGATE can also exclude error cells and more.

hernantorres23

Active Member
Joined
Nov 21, 2019
Messages
256
Office Version
365, 2016
Platform
Windows, Web
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
 

Watch MrExcel Video

Forum statistics

Threads
1,095,479
Messages
5,444,728
Members
405,298
Latest member
fxtrtr17

This Week's Hot Topics

Top