close

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

arrow
arrow
    全站熱搜
    創作者介紹
    創作者 software 的頭像
    software

    software

    software 發表在 痞客邦 留言(0) 人氣()