Copy a data set from one range into a different range in another tab using Macros

---

I want to copy data from the last column of the table below and paste all visible cells into a different range in a different tab (i.e. in this case the ``Net Income`` tab).

Here is a macro code that enabled me to do so:

Simply insert a code similar to this one (depending on which data fields you wish to export) and then run the VBA macro.

The results that show in the second tab (i.e. the ``Net Income`` tab) are illustrated below:

In my future blog posts I will demonstrate more complex examples of copying fields into different ranges using macros. So stay tuned :)

---