SUM in random files in the folder - VBA

M

Marina Limeira

I have files in the folder.

how I consolidate in new sheet all the files, to sum for region, products?

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 look with filename random ? and I not know the quantity file
for region.

But, all the worksheets have format the same.
Necessary they to charts with it, then I want create the table consolidate

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

chart to consolidate similar sheets files 0
sum in random files.xls how? 1
SUM all FILES... listbox? 0
Synchronization problems while moving folders to new email 1
Trying to create custom labels from an csv file + Need items numerically counted out 0
Unzipping and zipping .crtx files 0
Macro to copy files from Folders/Subfolders 3
IMPORTING EXISTING CHARTS INTO CONVERTED CSV-TO-XLS FILES 0

Top