Microsoft Excel can't map nonadjacent cells from the source spreadsheet to nonadjacent cells in a destination worksheet, however. While it has no problem linking groups of cells, nonadjacent cells ...

Doing so is helpful when you want to focus on data in the same data source in different ways. I’m using Excel 2016 on a Windows 64-bit system, but the feature is available in Excel 2010 and 2013.