greetings,
i'm on a search of an efficient way of creating a summary files from another 8 files. First let me explain:
1) Source files will be named - Jan_Sum.xls, Feb_Sum.xls, Mac_Sum.xls, etc
in the My Document folder
2) Output file(summary) will be named - Jan_Summary.xls, Feb_Summary.xls, etc. and will be saved into My Document folder as well.
Here's wut the data would look like:
DEC file:
JAN file:
These are the sample input files
i'm on a search of an efficient way of creating a summary files from another 8 files. First let me explain:
1) Source files will be named - Jan_Sum.xls, Feb_Sum.xls, Mac_Sum.xls, etc
in the My Document folder
2) Output file(summary) will be named - Jan_Summary.xls, Feb_Summary.xls, etc. and will be saved into My Document folder as well.
Here's wut the data would look like:
DEC file:
Book1 | |||||||
---|---|---|---|---|---|---|---|
B | C | D | E | F | |||
2 | FRUIT | ||||||
3 | type | Mar-06 | Apr-06 | May-06 | |||
4 | orange | Demand | 76 | 45 | 80 | ||
5 | Capacity | 100 | 100 | 100 | |||
6 | Loading % | 76% | 45% | 80% | |||
7 | |||||||
8 | banana | Demand | 10 | 13 | 40 | ||
9 | Capacity | 50 | 50 | 60 | |||
10 | Loading % | 20% | 26% | 67% | |||
11 | |||||||
Dec |
JAN file:
Book1 | |||||||
---|---|---|---|---|---|---|---|
B | C | D | E | F | |||
14 | FRUIT | ||||||
15 | type | Apr-06 | May-06 | Jun-06 | |||
16 | orange | Demand | 46 | 70 | 57 | ||
17 | Capacity | 100 | 100 | 100 | |||
18 | Loading % | 46% | 70% | 57% | |||
19 | |||||||
20 | banana | Demand | 5 | 32 | 40 | ||
21 | Capacity | 50 | 50 | 60 | |||
22 | Loading % | 10% | 64% | 67% | |||
23 | |||||||
Dec |
These are the sample input files