Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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
|
|||
|
|||
![]()
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
|
|||
|
|||
![]()
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 | |
|
|
![]() |
||||
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) |