Excel - Link data from one cell to another

March 2017





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


Published by aakai1056.
This document, titled "Excel - Link data from one cell to another," is available under the Creative Commons license. Any copy, reuse, or modification of the content should be sufficiently credited to CCM (ccm.net).