| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Import data from several excel files into one file
I am trying to find a way of importing data from several different excel
files into different sheets of the same excel file (in a specific format). Then, I am planning to consolidate these sheets into one. The data that is going to be imported will be refreshed often. Please note that I would not like to use links. Thank you! |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Import data from several excel files into one file
Data--Import External data--
then select the address of the worksheet in "look in:" then select the desired Sheet from "Select table" window. "Aspa" wrote: I am trying to find a way of importing data from several different excel files into different sheets of the same excel file (in a specific format). Then, I am planning to consolidate these sheets into one. The data that is going to be imported will be refreshed often. Please note that I would not like to use links. Thank you! |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Import data from several excel files into one file in
Data--Import External data--Import Data
then select the address of the worksheet in "look in:" then select the desired Sheet from "Select table" window. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Excel 2007 Data Import from txt files | Excel Discussion (Misc queries) | |||
| USING DATA FROM AN EXCEL FILE TO IMPORT INTO ANOTHER | Excel Worksheet Functions | |||
| Import files on a:\...display in Excel file ? ... | Excel Discussion (Misc queries) | |||
| Import data from files with different names to EXCEL D'base. | Excel Discussion (Misc queries) | |||
| Import Excel Data from another workbook or file | Excel Discussion (Misc queries) | |||
Linear Mode
