Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
chart to consolidate similar sheets files
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 | |||
Data Range Mess | Charts and Charting in Excel | |||
Opening multiple Excel files that contain varied selected sheets | Excel Worksheet Functions | |||
Exporting multiple sheets to multiple htm files? | Excel Discussion (Misc queries) | |||
calculating excel spreadsheet files for pensions and life insurance (including age calculation sheets) | Excel Worksheet Functions | |||
Ignoring characters in excel sheets when creating a chart | Charts and Charting in Excel |