Our great sponsors
-
VBA-General
A repository of various modules and classes for interacting with Excel and doing other... things.
-
InfluxDB
Power Real-Time Data Analytics at Scale. Get real-time insights from all types of time series data with InfluxDB. Ingest, query, and analyze billions of data points in real-time with unbounded cardinality.
Yep, moving columns are a frequent issue that I encounter, which is why I made GetHeader and GetHeaders functions in my ExcelAPIs module. When it comes to comparing data between files, I tend to throw all the data into classes to keep track of everything. So in order to read the correct info from the correct columns, I've got read/write functions in each class that will read whatever pre-defined data is available and write data if it contains it. Only time issues arise is if new headers have to be defined, which thanks to the code being stored in the class as a separate function, only needs a couple lines of code added telling what that column should be stored as, and how to write that data.