Technology in terms you understand. Sign up for the Confident Computing newsletter for weekly solutions to make your life easier. Click here and get The Ask Leo! Guide to Staying Safe on the Internet — FREE Edition as my thank you for subscribing!
How do you link cells in different Workbooks in Excel?
[/al_question]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.
Subscribe to Confident Computing! Less frustration and more confidence, solutions, answers, and tips in your inbox every week.
I'll see you there!
Before commenting please:
Comments violating those rules will be removed. Comments that don't add value will be removed, including off-topic or content-free comments, or comments that look even a little bit like spam. All comments containing links and certain keywords will be moderated before publication.
I want comments to be valuable for everyone, including those who come later and take the time to read.
Hi am a newbie to VBA here, and just try to create a little payroll system. my aim is when a employee hrs is enter via form it would load the relvant book do calculation of i.e (hrs*Rate) and return it (Value)and display in on a form. looking for your help.
thankz
please help me
how to create Paste Link in the excel using vba code
regards,
SUNDER
How do I link multiple cells, from several worksheets, to one cell in my summary worksheet, in Excel 2002.
Using links between workbooks is known to be problamatic. You might look into LinkedCells at http://www.LinkedCells.com. It offers a very simple add-in that lets you share your Excel data with others in a publish/subscribe manner.
I am trying to link many workbooks to a single workbook. These workbooks are identical but in separate folders. When I copy and paste the template to the different folders, the path of the centrally linked workbook changes to match the path of the pasted templates. I want to keep this centrally linked workbook in a single location. How do I essentially freeze that path?
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, when i do entry in a cell of this Sheet name, then it show full data of those Sheet.
regards,
NEERAJ KUMAR
I want to link a cell in one worksheet to a cell in another so that when I update one, it updates the other automatically. This is not http links, just a link that keeps all linked cells identical. HELP!!!
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.
regards,
NEERAJ KUMAR
Okay, so I tested the “Paste Special” option and it works!
I’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.
Thanks
hi, thanks alot~! just what i need.
There are 5 tables for five different conditions.
I 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?
cheers.
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!
Dear Sir,
I would like to learn a to z about link command in excel
would you please help me in this regard
thanks & regards,
m.imad
I want to make a link from one area to another in the same worksheet but in reverse order
Is 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
Thanks
Hi,
I have built a “master database” which houses everyone who works for my company. The data is broken down so employees are grouped together by the branch they work at. I have also created a secondary database that is unique to the individual and not the branch. For example, the master database shows everyone who works at Location A, Location B, Location C etc and from that Person A at Location A has their own workbook linked back to the master database (EG A2). This means if i alter, for example person A’s contact number in the master database, his personal file will automatically update. My problem is that if someone joins my company at Location A, once i “insert” a new row to house the new persons data, Person A’s individual link now picks up whatever is in A2 and is not locked into the data assigned to Person A. How can i secure or lock this link so if i need to add people to the master database, all of my satellite databases for each individual is not thrown off by any new arrival?
Thanks
Can you help me figure out how to set up a Excel spreadsheet (source) so that it looks at selected cells in another Excel spreadsheet (target) and will update the cells when they are changed?
The source file is located at: \\Cmdnas01\HSC_SOLAR\Warehousing\Storage Logistics\Solar Warehousing S4 072509.xls
The target file is located at: \\Cmdnas01\HSC_DPHOST\Engineering\Reliability\Spares\S98 & St Charles Warehouses – Critical Spare Equipment List.xls
Note that there is a security warning at the top of the spreadsheet (see screen dump below) that the “automatic update of links has been disabled”. When I try to enable it all the cells lose their links?
I have a Excel documnet in the Sheet 1 Major Headings and Sheet 2 Splitings for Major Headings.
I want a solutions that when ever i want to see Splitings for Major Headings, i will click on beside Major heading cell and it will go to Sheet 2 Splitings for Major Headings.
Kindly hepl me.
Thanks-Sudhakar
How to make this?
If text (Sheet1) inside of A1 fild is same as one of the names of sheets (Sheet1) than take info from that sheet (Sheet1) and from fild A2
Hi, I have 2 work sheets. On sheet 1 is a list of employees names, phone number, addresses etc and on sheet 2 is the same list but a printable version. What i need to do is say a phone number changes, rather than go to both sheets and type the phone number again, I want to link heet one – type the change and sheet 2 changes automatically. How ????
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
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
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.
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.
why the link destination worksheet was break after I added a new row at the middle of the row ?