Link data from one cell to another

bu7129 - Nov 29, 2009 at 10:56 PM
 k - Oct 22, 2015 at 03:21 AM
ok now what I am trying to do is make a simple formula that will let me take some data out of work book a and have it appear in work book B. is that possible if possible I would like to do this with a whole column at once but can do cell by cell if I have to.

1 response


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 hit 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.

Best regards,
Thank you so much. It worked perfectly. Makes my life so much easier now. thanks again.
worked great