fabianj
04-06-2016, 03:06 AM
Hi,
Please find the attached excel sheet.
My objective is to get values from Sheet1 to Data for individual people. I have to find the "no. of 1's, no. of 2's for each people....
I did the coding but I feel this is not the right way. So far I am getting values individually in values_1(), values_2() so on... can these be grouped to one (in a for loop), it would be great if you can help and advice me on this.
Problems:
1. Need advice to group all the Values_1(), Value_2() ...
2. If re-run the macro with sheet1 as active window I get the results which supposed to be on "Data" copied on sheet1 itself.
Please note: Please run the macro (mainproject () )once you open the sheet.
Awaiting for your earnest reply.
Thanks
Fabian J
15845
Please find the attached excel sheet.
My objective is to get values from Sheet1 to Data for individual people. I have to find the "no. of 1's, no. of 2's for each people....
I did the coding but I feel this is not the right way. So far I am getting values individually in values_1(), values_2() so on... can these be grouped to one (in a for loop), it would be great if you can help and advice me on this.
Problems:
1. Need advice to group all the Values_1(), Value_2() ...
2. If re-run the macro with sheet1 as active window I get the results which supposed to be on "Data" copied on sheet1 itself.
Please note: Please run the macro (mainproject () )once you open the sheet.
Awaiting for your earnest reply.
Thanks
Fabian J
15845