After learning how to record Macros, it is important to learn how to amend the codes. But before you can do that, you need to have some basic knowledge about how Macros write and read from cells and ranges, how to refer to different worksheets and workbooks. With this knowledge, you will be able to modify the recorded macros and have more control over the behaviour of the macros when it is used by you or your users. In this video, we will show you the basics of macros so that you can modify your recorded macros to make them more robust.
In the video below, you will learn how to navigate from worksheet/workbooks to another and also how to read and write to different worksheets/workbooks.