This is a brief overview of the Loop Macro tool (a part of XLTools Add-in for Excel). For Microsoft Excel 2010 - 2019, desktop Office 365. Download and take a 14-day free trial at https://xltools.net/download-free-trial/.
0:00 Introduction to Loop Macro tool
0:11 Review and back up the files
1:05 Record changes as a macro
2:23 Select the files to loop through
2:42 Click Run and start processing
3:26 Add XLTools to Excel