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?
|