Excel - Link data from one cell to another

June 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. Latest update on January 15, 2010 at 09:42 AM 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).