Import Excel Data from another workbook or file

T

tamato43

Is there a way to import or export Excel Data between 2 different workbooks?

E.G. Import from "File A" 'Sheet1' Column A, Row2 to "File B" 'Sheet1'
Column A, Row 2.

What I'd like to do ultimately is import data from 5 excel files into one.
 
G

Gordon

tamato43 wrote:
|| Is there a way to import or export Excel Data between 2 different
|| workbooks?
||
|| E.G. Import from "File A" 'Sheet1' Column A, Row2 to "File B"
|| 'Sheet1' Column A, Row 2.
||
|| What I'd like to do ultimately is import data from 5 excel files
|| into one.

Have you thought of linking the files together? Or is this a one-off in that
the files you want to "import" from don't change?
 
Top