Excel - Import & combine

P

petergle

At the end of everyday I import up 20 files into an excel worksheet
These are filesaves from a dos database and have no suffix. (Example
are OP1, OP2, etc)
Following the import I have a corresponding number of open workbooks
the contents of which I manually cut and paste into another workboo
(onto a single page) in which I extract the required information.

Can anybody help me automate this process.

To my limited way of thinking, the process would need to consider th
following:

Import files
Select Drive/select files
convert to Excel
Combine all on open worksheet

Thanks in advance for any advice give
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Reformat Excel for Access import 1
how do i combine excel worksheets 1
Import Several .txt Files 2
Import more than one .csv file into the same Excel file. 1
import XML data...Is there a size limit on the import? 0
How to combine two different excel files 1
xml import....Size limit?? Can the XML file be split?? 0
Import Multiple XML Files into Excel 3

Top