Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Multiple workbook data imported into single workbook
I have 7 workbooks with 15 columns of data in each. All 15 columns have the
same labels. I need to import all the data from each workbook into a single workbook with no gaps betweem rows and all in a single page. Example: Workbook 1 has 5 rows of data in 15 columns, workbook 2 has 8 rows of data in 15 columns, workbook 3 has 25 rows of data in 15 columns, workbook 4 has 18 rows of data in 15 columns, workbook 5 has no data in 15 columns, workbook 6 has 43 rows of data in 15 columns and workbook 7 has 7 rows of data in 15 columns. I need all this data to be imported into workbook 8 with 15 columns so the data is in ascending rows with no gaps between rows. How can I do this? -- SaipanRick |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Multiple workbook data imported into single workbook
Sorry, this is a pretty low-tech answer.
But why don't you just highlight the cells in the workbook you want to take data from, then press "Ctrl-V" (to copy) then go into the workbook you want to put data into, select the cell you want to start pasting the data into, and press "Ctrl-V" to paste? -- "SaipanRick" wrote: I have 7 workbooks with 15 columns of data in each. All 15 columns have the same labels. I need to import all the data from each workbook into a single workbook with no gaps betweem rows and all in a single page. Example: Workbook 1 has 5 rows of data in 15 columns, workbook 2 has 8 rows of data in 15 columns, workbook 3 has 25 rows of data in 15 columns, workbook 4 has 18 rows of data in 15 columns, workbook 5 has no data in 15 columns, workbook 6 has 43 rows of data in 15 columns and workbook 7 has 7 rows of data in 15 columns. I need all this data to be imported into workbook 8 with 15 columns so the data is in ascending rows with no gaps between rows. How can I do this? -- SaipanRick |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Multiple workbook data imported into single workbook
I need this to be automated when the workbook users enter data in their
workbooks the master summary workbook automatically imports the data from all 7 workbooks into a single page in the summary workbook. -- SaipanRick "jiml" wrote: Sorry, this is a pretty low-tech answer. But why don't you just highlight the cells in the workbook you want to take data from, then press "Ctrl-V" (to copy) then go into the workbook you want to put data into, select the cell you want to start pasting the data into, and press "Ctrl-V" to paste? -- "SaipanRick" wrote: I have 7 workbooks with 15 columns of data in each. All 15 columns have the same labels. I need to import all the data from each workbook into a single workbook with no gaps betweem rows and all in a single page. Example: Workbook 1 has 5 rows of data in 15 columns, workbook 2 has 8 rows of data in 15 columns, workbook 3 has 25 rows of data in 15 columns, workbook 4 has 18 rows of data in 15 columns, workbook 5 has no data in 15 columns, workbook 6 has 43 rows of data in 15 columns and workbook 7 has 7 rows of data in 15 columns. I need all this data to be imported into workbook 8 with 15 columns so the data is in ascending rows with no gaps between rows. How can I do this? -- SaipanRick |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Multiple workbook data imported into single workbook
Woops, I meant Ctrl-C to copy, of course.
Typo. .< Jim "jiml" wrote: Sorry, this is a pretty low-tech answer. But why don't you just highlight the cells in the workbook you want to take data from, then press ***"Ctrl-C"*** (to copy) then go into the workbook you want to put data into, select the cell you want to start pasting the data into, and press "Ctrl-V" to paste? -- "SaipanRick" wrote: I have 7 workbooks with 15 columns of data in each. All 15 columns have the same labels. I need to import all the data from each workbook into a single workbook with no gaps betweem rows and all in a single page. Example: Workbook 1 has 5 rows of data in 15 columns, workbook 2 has 8 rows of data in 15 columns, workbook 3 has 25 rows of data in 15 columns, workbook 4 has 18 rows of data in 15 columns, workbook 5 has no data in 15 columns, workbook 6 has 43 rows of data in 15 columns and workbook 7 has 7 rows of data in 15 columns. I need all this data to be imported into workbook 8 with 15 columns so the data is in ascending rows with no gaps between rows. How can I do this? -- SaipanRick |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Multiple workbook data imported into single workbook
Hi,
Unless I have missed-understood, there is so little data that I would just copy and paste each workbook into workbook 8. When all the data is on one sheet, select it all and sort by whatever column you want. Regards - Dave. "SaipanRick" wrote: I have 7 workbooks with 15 columns of data in each. All 15 columns have the same labels. I need to import all the data from each workbook into a single workbook with no gaps betweem rows and all in a single page. Example: Workbook 1 has 5 rows of data in 15 columns, workbook 2 has 8 rows of data in 15 columns, workbook 3 has 25 rows of data in 15 columns, workbook 4 has 18 rows of data in 15 columns, workbook 5 has no data in 15 columns, workbook 6 has 43 rows of data in 15 columns and workbook 7 has 7 rows of data in 15 columns. I need all this data to be imported into workbook 8 with 15 columns so the data is in ascending rows with no gaps between rows. How can I do this? -- SaipanRick |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I set up a single header for a multiple sheet workbook? | Excel Discussion (Misc queries) | |||
Creating a single workbook from multiple workbooks | Excel Discussion (Misc queries) | |||
Consolidate multiple spreadsheets into a single workbook | Excel Discussion (Misc queries) | |||
Data compilation within a single workbook | Excel Worksheet Functions | |||
continuous page numbering multiple sheets of a single workbook? | Excel Worksheet Functions |