Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Copying individual files (workbooks) into worksheets
I have 100+ files in the name of DEPTxxx.xls - where xxx is the number. Can
I open all of them or at least get the contents copied to a worksheet in my active document rather than one at a time? Each of the files or individual workbook contains two worksheets - the values from the individual workbooks will be copied to another worksheet that represent a summary. Any idea's? |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Saving worksheets within workbooks as individual files | Excel Worksheet Functions | |||
Importing XML files into individual worksheets | Excel Discussion (Misc queries) | |||
How do I separate worksheets in a workbook into individual files? | Excel Worksheet Functions | |||
Can I split worksheets from one workbook into individual workbooks | Excel Discussion (Misc queries) | |||
Copying worksheets across workbooks | Excel Programming |