Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
extract data from multiple workbooks
I have 293 excel files, each comprised of a number of worksheets, and each
containing statistical information on a different area (the same type of information, but obviously each area has different values; the same naming conventions are used for each file/worksheet). What I want to do is to extract selected worksheets from each file and merge them into one so I can convert this to DB4 format to use in GIS mapping. Obviously I can cut and paste individually....but... Therefore, does anyone know of a macro/function etc that I could use to say; for example: select source files, worksheet b4, range a3 - m17, paste in destination file (preferably appended on the same worksheet and not in separate worksheets). The original files are full of text, hyperlinks, odd naming conventions etc which DB4 doesn't like; as well as information I don't need. Does anyone have any idea how I might go about doing this (will save me months of work...or megabucks to get the processed data from the bureau of statistics). |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
extract data from multiple workbooks
Hi Heather:
Have you considered an Excel add-in like this one. http://www.digdb.com/excel_add_ins/c..._sheets_files/ ? If you type merge excel files or combine excel file or append excel files in Google you will get many more tools like this one. Best regards, Christophe |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
extract from multiple workbooks in a folder | Excel Discussion (Misc queries) | |||
Excel Workbooks, user returns, extract unique data | Excel Discussion (Misc queries) | |||
extract data from multiple worksheets | Excel Worksheet Functions | |||
How to extract data from multiple worksheets.. | Excel Discussion (Misc queries) | |||
How do I extract cells from multiple workbooks | Excel Discussion (Misc queries) |