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.
Also exemples help me very much...

thanks

Marina

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

software

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

E-mail轉寄