Need help real badly, i have to prepare summary report of simulator boxes utilization and prepare trend charts. For this need help on macro.
Multiple input files(can be in one single directory c:/tmp/): File_date1.xls, File_date2.xls, File_date3.xls, File_date4.xls... 30 files
Another catch is min, max and avg are formula in input sheet, however need to copy only value to master sheet.
Sample File_date1.xls file, here every alternate column data is required. physical location between box1 and box2 data is fixed:
A B C D E F G H I J K
Box1 xx xx Box2 xx xx Box2 xx xx BoxN
Min 1 xx xx 1 xx xx 1 xx xx 1
Max 4 xx xx 4 xx xx 4 xx xx 4
Avg 3 xx xx 3 xx xx 3 xx xx 3
required master_file.xls in following format using above multiple files using macro:
A B C D E F G H I J K
Box1_Date1 Box1_Date2 Box1_Date3 Box1_Date4 .. ..
Min 1 1 1 1
Max 4 4 4 4
Avg 3 3 3 3
Box2_Date1 Box2_Date2 Box2_Date3 Box2_Date4 .. ..
Min 1 1 1 1
Max 4 4 4 4
Avg 3 3 3 3
Box3_Date1 Box3_Date2 Box3_Date3 Box3_Date4 .. ..
Min 1 1 1 1
Max 4 4 4 4
Avg 3 3 3 3
..
..
BoxN_Date1 BoxN_Date2 BoxN_Date3 BoxN_Date4 .. ..
Min 1 1 1 1
Max 4 4 4 4
Avg 3 3 3 3
Bookmarks