How to create a macro that combines data from multiple files into a master file.

This video will demonstrate and describe the construction of a macro which will combine data from multiple files into a master file
In this example, after completion the macro can be run with one click and combine sales data from two branches into a Head Office file.

Screen recording software: Camtasia22 for Windows 18.00
Hardware: Dell 24 2700 all-in-one 1tb hd 8mb RAM 23.8" touch screen
Operating system:Windows 10