Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
importing data?
Is there any way to import data from 3 workbooks in another workbook? ...a
database workbook to import all data in this 3 workbooks? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
importing data?
Copy the sheets of the three workbooks into the database workbook.
-- Gary''s Student - gsnu200794 "puiuluipui" wrote: Is there any way to import data from 3 workbooks in another workbook? ...a database workbook to import all data in this 3 workbooks? |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
importing data?
Open the destination worklbook and the source workbook. Then copy the source
worksheet by right clicking on the tab on the bottom of the worksheet (normally sheet1) and select move/copy. then select the destination workbook and the location where you want the new sheet. Then close the source workbook and open then second source workbook and repeat the process. "puiuluipui" wrote: Is there any way to import data from 3 workbooks in another workbook? ...a database workbook to import all data in this 3 workbooks? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Removing Data Tables formed from importing data from Access | Excel Discussion (Misc queries) | |||
Importing Data: OLE DB and data link properties dialog | Excel Discussion (Misc queries) | |||
Data types when importing Excel data to SQLServer | Excel Discussion (Misc queries) | |||
Importing data, then adding data to the new spreadsheet.. a conund | Excel Discussion (Misc queries) | |||
Importing Data & Refresh Data Problem | Excel Discussion (Misc queries) |