Hacker News Reader

Here are some links that may help solve your problems.

Comparing spreadsheets is standard since Excel 2013.

https://support.office.com/en-us/article/compare-two-version...

Power Query may be of use to automate ETL type processes, which is standard since Excel 2016 and is a free add-on prior:

https://support.office.com/en-us/article/introduction-to-mic...

View on HN

Those would be great solutions but we're stuck on Excel 2007 and can't install any newer versions or basically any software because of IT reasons.

Office 2007 hasn't even been Extended Supported for two years now. That seems an egregious information security problem and your IT may need at least some modest sanity checks.

https://support.microsoft.com/en-us/help/3198497/office-2007...

Reply on news.ycombinator.com