Link data from one cell to another

Solved/Closed
bu7129 - Nov 29, 2009 at 10:56 PM
 k - Oct 22, 2015 at 03:21 AM
Hello,
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

Hi,

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,
Trowa
2
Thank you so much. It worked perfectly. Makes my life so much easier now. thanks again.
0
worked great
0