Helping people with computers... one answer at a time.
You can easily link cells across workbooks in Excel. In fact, Excel itself will do most of the work for you.
How do you link cells in different Workbooks in Excel?
•
The Paste Link command is probably what you want.
Select the item you want to copy in one workbook and select Edit, Copy. Now in the other workbook, select the desired destination, and hit Edit, Paste Special, and press the Paste Link button.
If you take a look at the resulting formula it should include the filename, sheet name, and cell reference to original data.
•
Article C1963 - May 30, 2004 « »
Leo A. Notenboom has been playing with computers since he
was required to take a programming class in 1976. An 18 year career as a programmer at Microsoft soon followed.
After "retiring" in 2001, Leo started Ask Leo! in 2003 as a place for answers
to common computer and technical questions. More about Leo.
September 30, 2011 11:51 PM
How do I reference a cell (like A1) in the source worksheet, on the server mdnas01:
\\Cmdnas01\HSC_SOLAR\Warehousing\Storage Logistics\Solar Warehousing S4 072509.xls
I have mapped server ISD$ to "J", and when I use "J" I am OK, but when I use the server name "ISD$", I am getng an error on:
=\\isd\isd$\ACC-ISD\CBAD\Team-Weekly-Updates\Testing Apps and STATUS\BHART - Test Case Matrix.xls\['V15+W7,IE8,O2010]'!K37
Could you help me?
Thanks
November 17, 2011 6:44 PM
Dear Sir,
I want to link some rows but larger than one page in microsoft word, so can not see some rows in the sheet.
Can you help me?
Many thanks
December 15, 2011 10:25 PM
Hi sir,I want to prepare a excel work sheet 1 with multiple rows & columns,I want the updates on other work sheet for month wise automatically when it is updated on work sheet 1.Send me visual format only for excel work sheet.
December 27, 2011 4:23 AM
I have made a list of contacts (friends etc) in excel. Is there a way to have their phone number so I can just touch it to dial? Thank you in advance.
February 7, 2012 9:01 PM
why the link destination worksheet was break after I added a new row at the middle of the row ?