MS Excel: How to pull and link data from one spreadsheet to another.

[flynbrian99]

MS Excell: Can anyone tell me how to pull and link data from one spreadsheet to another.


Thanks,

flynbrian-

 

[sawedoff]

Just enter the other workbook name, followed by !, then the page name and cell. Example: =[Book1]Sheet1!$C$6 would bring in the contents of call C6 from page Sheet1, in workbook Book1. If the other workbook is not open, at the time, you need to list the full path if it is not in the same folder as the file you are editing.

Sawedoff

 

[flynbrian99]

Will this pull data from the workbook as well?

flynbrian-

 

[sawedoff]

I'm not sure what you are asking. It will pull the data from the referenced cell in the other workbook, is that what you mean?

Sawedoff

 

[flynbrian99]

Yes, but will it auto update along with the data from the other sheet?

 

[sawedoff]

When you open a workbook that has linked data, it will ask you if you want to update it, or you can update it manually in Edit-Links-Update now. If both workbooks are open, it will update automatically if you have your options set to do that.

Sawedoff

 

[flynbrian99]

Example: =[Book1]Sheet1!$C$6

Do I need to put brackets around the name of the workbook?
It does not seem to be working. Here is what I typed in...
[Performance Log]sheet1!$L$75

Thanks,

flynbrian-

 

[flynbrian99]

Where should I be typing this formula?

 

[sawedoff]

Yes you need the brackets, sorry. You will need an = or + if what you want is just the contents of the cell. Put the formula in the cell where you want the results to be.


Sawedoff

 

[KenWright]

One way to do this is to have two files open and do Window / Arrange / Tiled. Click on any cell in one of the sheets, type = and then using the mouse click on another cell in the other sheet you can see. You will now see how the reference is built. If you then close the file you have linked 'to', you will see that the reference expands to become a full file reference now.

Regards
Ken.......

----------------------------------------------------------------------------
It's easier to beg forgiveness than ask permission

----------------------------------------------------------------------------

 

[flynbrian99]

LOL...I am not sure what I am doing wrong, but this is not working. I opened a new spreadsheet and in cell A1 I typed the following: =[Performance Log]sheet1!$L$75. I have both spreadsheets opened. What am I doing wrong?

flynbrian-

 

[sawedoff]

Are you getting an error message, or just not the results you expected? This sounds rather elementary, and I don't mean to insult your abilities, I like to check the obvious first. Is the page you want named Sheet1?

Sawedoff

 

[fredericofonseca]

Do it the way Ken mentioned, and see if it is different from the way you typed it. (probably is).

Regards

Frederico Fonseca
SysSoft Integrated Ltd

http://www.syssoft-int.com

 

[Kiyamu]

Here is the problem: Your file name has a space in it. Which is fine to have, however the link has to be made a little differently.

='[Performance Log]sheet1'!$L$75

Whenever you have a space in the workbook name or the file/workbook name you must put in the single quotation marks to describe the link.

Also the workbook name in brackets must be made to be identical to what shows up in the title bar of the workbook. So, if at the top of the window the name is Performance Log.xls you must make the link using:

='[Performance Log.xls]sheet1'!$L$75

There you go!

Cameron
IBACOS, Inc.