Hi,
I am new to the forum and came here to meet people and ask for help learning excell vba. I hope I meet lots of new friends and people where I can learn from.
I have a difficult task ahead.
I have 17 workbooks with colums of data. Every workbook is the same, the difference is the week the data is from (week 1-17)
I need to consolidate data of say 12 rows with 20 colums into 1 mastersworkbook.
the 12 rows represent 12 peoples weekly data, the 20 row the different metrics they achieved weekly.
I now need a masterworkbook, where every person has a tab there and then represent the data so I have an overview per person for 17 weeks what there achievements are on the different outlined metrics to see week roling data on 1 sheet. (17 weeks on 1 sheet for 1 person, all their metrics)
If I have to do this manualy I will be copying data from 17 sheets, 1 person at the time and 1 metric at the time, opening closing 17 sheets all the time to paste it in the master sheet.
This must be possible to simplify.
I recorded a macro, to copy certain colums (as dont need all 20) from the workbooks to the masterbook. This macro works on all sheets.
The problem comes in when I want to paste the data of the second workbook on the second row. Must I make 17 macro's to achieve this line by line or is there an easier way to achieve this daunting task?
I am new to the forum and came here to meet people and ask for help learning excell vba. I hope I meet lots of new friends and people where I can learn from.
I have a difficult task ahead.
I have 17 workbooks with colums of data. Every workbook is the same, the difference is the week the data is from (week 1-17)
I need to consolidate data of say 12 rows with 20 colums into 1 mastersworkbook.
the 12 rows represent 12 peoples weekly data, the 20 row the different metrics they achieved weekly.
I now need a masterworkbook, where every person has a tab there and then represent the data so I have an overview per person for 17 weeks what there achievements are on the different outlined metrics to see week roling data on 1 sheet. (17 weeks on 1 sheet for 1 person, all their metrics)
If I have to do this manualy I will be copying data from 17 sheets, 1 person at the time and 1 metric at the time, opening closing 17 sheets all the time to paste it in the master sheet.
This must be possible to simplify.
I recorded a macro, to copy certain colums (as dont need all 20) from the workbooks to the masterbook. This macro works on all sheets.
The problem comes in when I want to paste the data of the second workbook on the second row. Must I make 17 macro's to achieve this line by line or is there an easier way to achieve this daunting task?
Last edited:
