2006-11-13 04:32:51 · 4 answers · asked by Earl Jnr 1 in Computers & Internet ➔ Programming & Design
Yes, you can but are you talking about linking two worksheets in a workbook or two totally different workbooks? The complete cell address for a workbook to workbook link would look like this
'[workbook.xls]Sheet1'!$A$14
The easiest way to link across workbooks is to open both workbooks and switch to the source workbook (click window, and workbook name) then copy the cell location(s) into memory. Then switch to the target workbook click into the target cell, right click the mouse, select paste special, and click the paste link button. The value in the link will automatically update everytime you open the target worksheet.
2006-11-13 04:49:32 · answer #1 · answered by Brian K² 6 · 0⤊ 0⤋
Ever because of shown actuality that I joined fb (quickly) and then left, their contacts list has get up after I compose a letter on Yahoo and attempt to import an take care of from my Yahoo contacts list. The previous contacts list continues to be there in Yahoo, yet now not comes up on the take care of line after I form interior the first few letters of the decision of the guy i want the letter to bypass to. really, up comes fb's human beings, really some whom i have were given through no skill heard of, pictures lined! How am i waiting to get rid of them? thanks.
2016-11-23 19:39:11 · answer #2 · answered by vanderburg 4 · 0⤊ 0⤋
yes..it automatically updates..that is the main use of linking after all. isn't it?
2006-11-13 04:40:26 · answer #3 · answered by shanthicharuvil 3 · 0⤊ 0⤋
Yes, but you will have to write some Visual Basic code.
2006-11-13 04:38:20 · answer #4 · answered by Chris B 4 · 0⤊ 0⤋