Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
SUM all FILES... listbox?
I have XLS files with the same formating of production fruits from region,
in the same folder. how I consolidate in new sheet all the files, to sum for region, fruit-products? And I want create automatic charts too. OBS: I not know the amount of files in this one folder, so I know that the these nominated archives for region, a994.xls region A, b423.xls b323.xls region B .... How to create a looping with random filename ? and I not know the quantity of files for region. But, all the worksheets have format the same. I want create a ListBox for choose the regions for sum per example Also exemples help me very much... thanks Marina |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Recently Used File List - 2002 Contains 'Temp' Files | Excel Discussion (Misc queries) | |||
merging my excel files | Excel Discussion (Misc queries) | |||
Cannot access read-only documents. | Excel Discussion (Misc queries) | |||
multiple text files URGENT | Excel Discussion (Misc queries) | |||
importing multiple text files URGENT!!! HELP | Excel Worksheet Functions |