Previous Topic Next Topic

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.
Related:

1 response

Answer 1 / 1
Trowa
Nov 30, 2009 at 08:18 AM
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
bu7129
Nov 30, 2009 at 10:29 AM
Thank you so much. It worked perfectly. Makes my life so much easier now. thanks again.
0
k
Oct 22, 2015 at 03:21 AM
worked great
0

Similar discussions

Messenger group link
aivaras1963 -
dwebb -

3 responses
Unlock safe folder without losing any data
Mintu -
HelpiOS -

1 response
Please give me link to unlock my Facebook account
Andeccuasay -
HelpiOS -

1 response
How to undo "remove link" in bio?
mary22 -
Gourav -

13 responses
Undo remove link
Sam -
Abhishek0025 -

1 response