Moving between workbooks with the mouse is how most people do this in Excel However, with VBA all of this can be made automated for various purposes. The video below shows you how to code this process using VBA,