Home |
Search |
Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Compiled data from many files
How can I get a compilation of data from several files? For example
01.xls: a aaa 5 a bbb 6 a ccc 7 b ddd 4 c eee 6 c fff 8 02.xls: a ggg 8 a hhh 2 b iii 3 c jjj 4 03. xls: a kkk 9 c lll 4 and the result I want would look like compilation.xls (gets data from three files 01-03.xls) a aaa 5 a bbb 6 a ccc 7 a ggg 8 a hhh 2 a kkk 9 b ddd 4 b iii 3 c eee 6 c fff 8 c jjj 4 c lll 4 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Compiled data from many files
This is what you want:
http://www.rondebruin.nl/copy3.htm Comes from he http://www.rondebruin.nl/tips.htm If you are unfamiliar with macros look at this: http://www.anthony-vba.kefra.com/vba...ur_First_Macro Regards, Ryan-- -- RyGuy "Unda" wrote: How can I get a compilation of data from several files? For example 01.xls: a aaa 5 a bbb 6 a ccc 7 b ddd 4 c eee 6 c fff 8 02.xls: a ggg 8 a hhh 2 b iii 3 c jjj 4 03. xls: a kkk 9 c lll 4 and the result I want would look like compilation.xls (gets data from three files 01-03.xls) a aaa 5 a bbb 6 a ccc 7 a ggg 8 a hhh 2 a kkk 9 b ddd 4 b iii 3 c eee 6 c fff 8 c jjj 4 c lll 4 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Reading data arrays from multiple data files in excel | Excel Discussion (Misc queries) | |||
Compiled error in hidden module: DistMon | Excel Discussion (Misc queries) | |||
Extracting Data for .Txt Files By Unique Field Data | Excel Discussion (Misc queries) | |||
Compiled Excel macros | Excel Discussion (Misc queries) | |||
How do I set up a Workbook with a master compiled worksheet and o. | Excel Worksheet Functions |