Excel - Link data from one cell to another

December 2016





Issue


I am trying to make a simple formula that will allow me take some data out of workbook A and transfer in Workbook B. Is that possible to transfer a whole

column at once but keep the possibilty to move data cell by cell if needed.

Solution


Open both workbooks, type in the destination cell in workbook B a "=", go to workbook A and select the cell you wish to take the data from and press enter. Look at the formula in the formulabar and remove both $ symbols. Drag the destination cell in workbook B down to take the data from the entire column of workbook A.

Thanks to Trowa for this tip on the forum.

Related :

This document entitled « Excel - Link data from one cell to another » from CCM (ccm.net) is made available under the Creative Commons license. You can copy, modify copies of this page, under the conditions stipulated by the license, as this note appears clearly.