MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Linking to data in another excel workbook


Posted by Linda Pascal on September 09, 2001 9:54 PM

How do I get the data in a certain column in one worksheet to appear in another column in another worksheet and to automatically update? I have tried to link to an object but this pastes a whole workbook into my open workbook, not just the cells of information I want. Can I specify the exact cells I want the information to come from?


Posted by Tom Urtis on September 09, 2001 10:17 PM

Try using the Paste Link feature. Select the cells in your source workbook and click Edit > Copy. Then select the corresponding cells in your destination workbook where you want the data to automatically appear, and click Edit > Paste Special > Paste Link. Note that this will sometimes make a "0" appear in destination cells where no data exists in source cells, so you can alternatively enter the formula manually in the destination cells as such (assumes your source data is in a workbook called FileABC, on Sheet1):

=IF([FileABC.xls]Sheet1!A1="","",[FileABC.xls]Sheet1!A1)

You may need to modify the formula for the source file's drive and file path.

Hope this is what you're looking for.

Tom Urtis