| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
sum in random files.xls how?
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. Also exemples help me very much... thanks Marina |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
sum in random files.xls how?
Marina,
Try he- http://www.rondebruin.nl/tips.htm "Marina Limeira" wrote: 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. Also exemples help me very much... thanks Marina |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Why do some Excel files I save have 36+ random characters on the e | Excel Discussion (Misc queries) | |||
| Seemingly random .tmp files | New Users to Excel | |||
| SUM in random files in the folder - VBA | Charts and Charting in Excel | |||
| Non-random numbers generated by excel's data analysis random gener | Excel Worksheet Functions | |||
| Non-random numbers generated by excel's data analysis random gener | Excel Discussion (Misc queries) | |||
Linear Mode
