ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Import Excel Data from another workbook or file (https://www.excelbanter.com/excel-discussion-misc-queries/15327-import-excel-data-another-workbook-file.html)

tamato43

Import Excel Data from another workbook or file
 
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.




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?

--
Interim Systems and Management Accounting
Gordon Burgess-Parker
Director
www.gbpcomputing.co.uk




All times are GMT +1. The time now is 06:28 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com