Complex Macro Set-up Question [Closed]

Report
Posts
1
Registration date
Sunday June 5, 2016
Status
Member
Last seen
June 5, 2016
-
Hello,
I need to set up a macro that takes data from 6 different excel files and deposits parts of them in a new file, in different order.

Efectivelly, I have 6 files with time data (20 time points) for 23 different categories. Each category has the number, sum, average and standard deviation columns. I need to just take the sum for each category (so every 5th column), and move this to a new file (a sort of mastersheet) where each category has the sum for each of the files side by side.

Eg. if I have 2 files with:

Interval Cat1 Cat2
# Sum Avg Std # Sum Avg Std
1 x1 x2 x3 x4 x5 x6 x7 x8
2 x1 x2 x3 x4 x5 x6 x7 x8
3 x1 x2 x3 x4 x5 x6 x7 x8
4 x1 x2 x3 x4 x5 x6 x7 x8
and
Interval Cat1 Cat2
# Sum Avg Std # Sum Avg Std
1 y1 y2 y3 y4 y5 y6 y7 y8
2 y1 y2 y3 y4 y5 y6 y7 y8
3 y1 y2 y3 y4 y5 y6 y7 y8
4 y1 y2 y3 y4 y5 y6 y7 y8

I want a new file with:
Interval Cat1 Cat2
1 2 1 2
1 x2 y2 x6 y6
2 x2 y2 x6 y6
3 x2 y2 x6 y6
4 x2 y2 x6 y6

Except for 6 files, with 20 intervals, with 23 categories.
I have no idea where to even start with this, so any help is appreciated.

Thanks,
Sam

Subscribe To Our Newsletter!

The Best of CCM in Your Inbox

Subscribe To Our Newsletter!