Copy range as link  

This useful tool allows you to paste a cell range to get linked to the original range.

When Excel pastes cell ranges as links, it also does it over empty cells.
We show you the next procedure as an alternative:

1.- Select a cell range.
2.- Click in the tool box to visualize the dialog box showed in the next .


3.- Pick a cell to paste the results, in this case it will be cell D2.

If you want you can include formats putting the check to the correspondent option.
In this case we are not going to do this. Take a look at the results.