Search First! Then browse:
Categories |
Full Archive |
By Date |
Newsletter
Summary: 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
please help me
how to create Link from a cell in different worksheet excel using vba code or function.
I want to know that, there are more than sheet from Month Name such as Jan 08, feb 08, I want to do that In report cell Entry the Data and it goes into different sheet.
Posted by: Neeraj Kumar at March 18, 2008 9:05 PMregards,
NEERAJ KUMAR
Okay, so I tested the "Paste Special" option and it works!
Posted by: Gavrick at April 17, 2008 9:13 PMI'm trying to create one spreadsheet where I enter data on a daily basis, but I only want to enter this data in one row.
I would like to link another workbook to this spreasheet that keeps historical data.
In other words, when I enter numbers into "Spreadsheet A" on Day One that same info will appear in "Spreadsheet B", Day One.
On Day Two I will write over the info from the previous day on "Spreadsheet A" and that info will appear in "Spreadsheet B" on the next row for Day Two, and so on.
Does this require an "If,And" condition?
i have ten worksheets. each work sheet has 10 different peoples name adress age phone numbers. I have one summary worksheet as well. i need a formula to find oldest person's name age and address from each worksheet and automically put into summary sheet. Please advice.
Posted by: ar at May 28, 2008 11:30 AMThanks
hi, thanks alot~! just what i need.
Posted by: liyen at July 29, 2008 9:34 AMThere are 5 tables for five different conditions.
Posted by: shri at October 18, 2008 3:28 AMI want to get a value which will be extracted after checking for all five conditions.How to create formula?
i want to:
enter data into ONE cell, and when i do so, 3 different cells mirror the data -
example: i type '8989' into B13. As i type this, '8989' appears in B14,B15, and B16. When i change the data in any of these cells, it changes also in the others.
any clue how to do this?
Posted by: Dan at December 8, 2008 7:10 PMcheers.
I'm linking data on one worksheet to another in the same workbook. When I alter the worksheet where the original data is entered (ie: sort based on changing numbers such as sales per representative), it alters the linked data in the other worksheet ie: the sales rep names are now no longer aligned with the correct sales numbers. I've used a function utilizing $ $ to bracket the destination cells so that I can sort that page but the original source worksheet cannot be sorted with out messing up the data on the linked worksheet. How do I keep that from happening? Thanks!
Posted by: Jay Clarke at February 4, 2009 7:44 PMDear Sir,
I would like to learn a to z about link command in excel
would you please help me in this regard
thanks & regards,
Posted by: Muhammad Imaduddin at March 31, 2009 11:18 PMm.imad
I want to make a link from one area to another in the same worksheet but in reverse order
Posted by: Daniel Tsvetanov at April 27, 2009 1:10 AMIs it possible to use relative pathing to link two workbooks in the same directory?
'.\[book1.xls]sheet1'!$a$1
instead of c:\temp\[book1.xls]sheet1'!$a$1
I need to send several link workbooks to someone who is on a different file server
Posted by: greg at September 3, 2009 4:34 PMThanks