chart to consolidate similar sheets files

M

Marina Limeira

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

SUM in random files in the folder - VBA 0
sum in random files.xls how? 1
SUM all FILES... listbox? 0
One Chart, Same Data ranges, different source sheets 4
IMPORTING EXISTING CHARTS INTO CONVERTED CSV-TO-XLS FILES 0
Summary sheet in effecient way 0
Compatibility error when saving file. 4
Importing existing charts into newly created .XLS files 1

Top