How to pull data from another excel file.

Microsoft Microsoft office excel 2007 ac...
July 4, 2011 at 09:38:09
Specs: Windows 7
How can I pull data from another excel file (say File1.xls) to show it on a cell on Sheet1 of File2.xls ?

For example:

File2.xls Sheet1 A1 = File1.xls Sheet1 A1

See More: How to pull data from another excel file.

Report •

July 4, 2011 at 17:06:14
It's basically done the same way as any other =A1 or =Sheet2!A1 is done, except that the formula will include the file name.

The easiest way is to follow these steps:

Open both files.

Enter an equal sign in File2.xls Sheet1 A1 and then click in File1.xls Sheet1 A1.

Press Enter.

With File1.xls open, you'll see the File name, Sheet name and cell reference.


When you close File1.xls, the formula will automatically change to include the full path to the file.

='C:\Documents and Settings\user name\My Documents\[File1.xls]Sheet1'!$A$1

Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.

Report •
Related Solutions

Ask Question