Excel 2007 : Linking Workbooks and Worksheets

[Treasure_7]

Hello:
I am really having trouble when it comes to linking Data between workbooks or worksheets. There are many linking combinations but I just don't seem to be getting the hang of it! Any suggestions would be very much appreciated!

[Paul]

Hi Treasure,

When linking between worksheets in the same workbook, you just need to add the sheet name and an exclamation point (!) before the cell reference(s). If your sheet name has any spaces in it, enclose the sheet name between apostrophes ('). For example:

=Sheet1!A7 ...... =Taxes!$G$14 ...... ='Bank Statement'!A18:A24

To link to other workbooks, you must include at least the workbook name (and if the other workbook is closed, the path to the workbook name). If there are any spaces in either the path, workbook name or sheet name, enclose that whole section in apostrophes (everything up to the !). Examples of this are:

=[Book1.xls]Sheet7!A3

='C:\documents\treasure\[portfolio b.xls]401k'!F2:F8

='\\server18\share2\files\abc\def\[book1.xls]Sheet8'!G7

Hopefully that helps you out!

[Treasure_7]

Thank-you for your detailed repy to my post. I see exactly what I have been doing wrong! Very much appreciation!!